Reputation
1,956
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 23
Newest
 Yearling
Impact
~72k people reached

Apr
17
awarded  Yearling
Mar
24
comment SQL server not using the memory allocated
Silly question, how large are the databases?
Mar
24
comment SQL server not using the memory allocated
First, what edition of SQL Server is this? (Enterprise, Standard, Workgroup, etc.). Secondly, tell us how you arrived at the conclusion that SQL Server is not allocating the memory, what tools did you use and what did you observe? Finally, how is your SQL Server being used, and what was going on in your SQL Server while you were making these measurements?
Feb
20
awarded  Popular Question
Jan
14
comment Defragmentation of SQL Server 2008 indexes
Explain how you know that it is not "changing fragmentation". Be specific.
Jan
5
awarded  Popular Question
Dec
12
comment Retrieve XML of large plan from plan cache
IIRC, you may have to create a new query window. You shouldn't have to restart SSMS, though that should also work.
Dec
12
comment Why does SQL authentication sometimes fail and how can I make it work reliably?
If "SQL Login does not work", then you are not doing it correctly. SQL Logins do NOT need to talk to the Domain Controller. Either you are not really doing a SQL Login, or your SQL Server has not been set to allow mixed mode authentication.
Nov
24
comment Performance decline function vs command window
We will need to see both of the query plans.
Nov
5
comment Trace Flag 1222 Not Working?
@kin yes, I am aware that I could use the system_health, or profiler, or extended events, etc., etc... All of these would require additional development, testing and deployment to integrate them into what the customer already has. I know how to do all of this and have done all of these at one time or another. That is not what I need help with. If I can correct the one broken server, that would be preferable to changing everything else.
Nov
4
revised Trace Flag 1222 Not Working?
added 529 characters in body
Nov
4
comment Trace Flag 1222 Not Working?
Sure, possible, but all of their servers are already setup this way, I don't want to have to change them all, if I can get just this one to work correctly. As for not using both, also possible, but right now, the 1204 is the only way I knew that a deadlock occurred on C and the 1222 did not report it.
Nov
4
asked Trace Flag 1222 Not Working?
Oct
6
comment How to add a default null row if no results from the dynamic pivot query
Even if there are no rows, a result set with defined columns is still returned to your application. Your application should be displaying the column headers even if there are no rows.
Oct
6
comment Defining a column as nullable in a view (but not in the referenced table)
+1: It's worth noting that there are some restrictions with this approach: 1) The changed columns are not writeable in the view, so if the OP's application tries to write to them, it would fail. And 2) the application must not try to distinguish between tables and views. Most apps do not, but annoyingly, some product applications do.
Sep
30
awarded  Explainer
Sep
18
comment Can't see some stored procedures in sys.procedures
Not sure why you posted 100+ lines of unformatted code for us to read, when it's only one four line query that's relevant.
Sep
18
comment How to monitor flat file for changes then run a SQL import job
I assume you mean from within the executing job, for which I am not sure, it's complicated. First thing is to set the Job as being owned by SA. Second thing is to test whether it works in a local folder. If it works locally, but not in the share, then it probably needs the Share/Folder/File settings changed.
Sep
18
revised How to monitor flat file for changes then run a SQL import job
added 884 characters in body
Sep
18
answered How to monitor flat file for changes then run a SQL import job