Reputation
32,287
Next tag badge:
978/400 score
79/80 answers
Badges
8 81 137
Newest
 Nice Answer
Impact
~1.0m people reached

May
3
reviewed Approve Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
May
3
revised INTERSECT query rewrite as JOIN?
added 202 characters in body
May
3
reviewed Edit Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
May
3
revised Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
Formatted question and spelling mistake
Apr
29
revised Change length of varchar on live prod table
added 541 characters in body
Apr
29
revised Deadlock error isn't returning the deadlock SQL
deleted 11 characters in body
Apr
29
revised Deadlock error isn't returning the deadlock SQL
added 151 characters in body
Apr
24
awarded  Nice Answer
Apr
21
awarded  Nice Answer
Apr
16
comment How can I replace the following query with ISNULL function in SQL?
Regarding the " performance optimization reasons" - except if there is a sub query involved any difference isn't worth worrying about
Apr
14
comment SQL Server - Changing a column from NOT NULL to NULL - What's going on under the hood?
@AaronBertrand - Thanks didn't spot that!
Apr
13
answered SQL Server - Changing a column from NOT NULL to NULL - What's going on under the hood?
Apr
13
comment SQL Server - Changing a column from NOT NULL to NULL - What's going on under the hood?
RandyMinder - This is new syntax for 2014. Search for WITH ( ONLINE = ON | OFF) <as applies to altering a column> in the link from @ypercube.
Apr
13
comment SQL Server - Changing a column from NOT NULL to NULL - What's going on under the hood?
After testing with referencing the column in an NCI which consisted of 1731 leaf pages, 7 2nd level pages and a root page and altering to NULL caused 1731 logged entries for LOP_FORMAT_PAGE,LCX_INDEX_LEAF and 7 for LOP_FORMAT_PAGE, LCX_INDEX_INTERIOR so does look to be not metadata only after all. Maybe for the reasons @souplex suggests.
Apr
13
comment SQL Server - Changing a column from NOT NULL to NULL - What's going on under the hood?
Probably blocked waiting on a SCH-M lock. Unlike the opposite case pretty sure this is metadata only. You can check sys.dm_os_waiting_tasks whilst it is blocked.
Apr
13
awarded  Enlightened
Apr
13
awarded  Nice Answer
Apr
9
comment UPDATE() Function (Insert and Update Triggers)
I don't think this is relevant? Pretty sure they are asking about this msdn.microsoft.com/en-us/library/ms187326.aspx
Apr
7
comment Can statistics affect the query logic instead of performance?
Yes this is entirely possible as discussed in this Connect Item connect.microsoft.com/SQLServer/feedback/details/537419/…
Apr
7
comment Unexpected Implicit conversion in a procedure
@Stackoverflowuser - No need to hurry.