Reputation
37,121
Next tag badge:
542/400 score
74/80 answers
Badges
8 97 156
Newest
 Enlightened
Impact
~1.4m people reached

Jan
7
awarded  Nice Answer
Jan
6
revised What does the position of the ON clause actually mean?
added 666 characters in body
Jan
6
revised What does the position of the ON clause actually mean?
added 1012 characters in body
Jan
6
answered What does the position of the ON clause actually mean?
Jan
6
comment Is nvarchar 0-indexed?
The column will take up to 4 bytes for the 2 dbcs characters and, usually, two bytes in the column offset array.
Jan
6
comment Avoiding a divide by zero error in a computed column
Do you intend to use integer division here or not?
Jan
5
comment Switching values in a column with one update statement
@YperSillyCubeᵀᴹ - Only in case sensitive collations (which aren't that usual IME)
Jan
5
revised Switching values in a column with one update statement
added 471 characters in body
Jan
5
comment Switching values in a column with one update statement
Let's hope all the M and W were entered in upper case to avoid unexpected 7 or ` -` appearing in the results.
Jan
2
comment Understanding the given correlated subquery
@zgguy - You seem to have typed that into the wrong box. Seems more answer than comment.
Jan
1
comment Unique Constraint that ignores soft deleted fields
CREATE UNIQUE INDEX uc_PartyUser ON PartyUser(PartyId,UserEmail) WHERE Deleted=0
Jan
1
revised What's the difference between a temp table and table variable in SQL Server?
added 467 characters in body
Jan
1
awarded  Nice Answer
Dec
31
comment How can I narrow down the cause of a deadlock after the fact?
Look in the default extended events session for the deadlock graph dba.stackexchange.com/a/10646/3690
Dec
31
revised 8k row overflow error when updating row of size 5k
deleted 95 characters in body
Dec
31
comment 8k row overflow error when updating row of size 5k
Similar to your last question. This error is whilst building a worktable for a sort too i.stack.imgur.com/wenSE.png, i.stack.imgur.com/MVyXf.png
Dec
31
revised How to remove line breaks in SSMS?
added 104 characters in body
Dec
31
revised How to remove line breaks in SSMS?
deleted 6 characters in body; edited title
Dec
31
revised How to remove line breaks in SSMS?
added 32 characters in body
Dec
31
answered How to remove line breaks in SSMS?