Reputation
31,553
Next tag badge:
486/400 score
71/80 answers
Badges
8 79 132
Newest
 Enlightened
Impact
~937k people reached

10h
comment Why is it truncate table, and not simply truncate?
@usr the first one is possible in 2016 msdn.microsoft.com/en-us/library/ms177570(v=sql.130).aspx
13h
comment Improve delete speed for SQL Server
Also. Any foreign key constraints? Please provide complete table definition, query, and execution plan.
2d
comment Good, Bad or Indifferent: WHERE 1=1
SQL Server also has a feature called simple parameterization that this pattern prevents though.
May
15
awarded  Enlightened
May
15
awarded  Nice Answer
May
13
answered How to Create key (to be used in join) using concatenation?
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.