Reputation
Next tag badge:
572/400 score
77/80 answers
Badges
8 104 164
Newest
 Nice Answer
Impact
~1.6m people reached

Apr
29
comment Conditionally add an index to a temp table
Is PKColumn the PK of the temp table? I.e. It's unique?
Apr
29
awarded  Enlightened
Apr
29
awarded  Nice Answer
Apr
29
revised Minimum value within a set (or window) within a three column table
Both introduced in same version
Apr
29
revised Define a proper index for a table
added 315 characters in body
Apr
29
answered Define a proper index for a table
Apr
29
comment sp_procoption seems to be failing on SQL 2005 instance
Does the code to set up the trace work correctly when you just run it outside a stored procedure in 2005. I suspect not so concentrating on sp procoption would be a red herring.
Apr
29
revised Does a single rollback affect all transactions?
added 117 characters in body
Apr
29
answered Does a single rollback affect all transactions?
Apr
28
comment Amazing improvement of script execution speed when split - not understood
@High no. In fact some people regularly do the exact opposite and assign parameters to variables to defeat parameter sniffing because of the side note. Using 'option recompile' with variables in your original script would have worked just as well and avoided the side note issue but then you pay for extra compilation time which might not be needed. Probably in your case it would be negligible compared to overall execution time without though.
Apr
28
revised Amazing improvement of script execution speed when split - not understood
added 2 characters in body
Apr
28
answered Amazing improvement of script execution speed when split - not understood
Apr
28
comment Execution time with warm up cache
Which situation is a user going to typically encounter? If you are confident that most of the time the data will be in cache then that will be the more representative value. Though you might still look at cold cache speed to see the worst case.
Apr
28
comment Amazing improvement of script execution speed when split - not understood
Is the original long script using variables that have become parameters in the new arrangement?
Apr
27
comment Script to Delete Tables With A Prefix
No it is never guaranteed. stackoverflow.com/questions/15138593/…
Apr
27
comment Script to Delete Tables With A Prefix
This is not a guaranteed approach to string concatenation connect.microsoft.com/SQLServer/feedback/details/606786/…
Apr
27
comment SPID Change for a process?
No this isn't possible.
Apr
27
reviewed Reject Where can I find the SQL Server to download?
Apr
27
revised Join two tables using pivot combining two columns in one table
edited tags
Apr
27
answered Join two tables using pivot combining two columns in one table