Reputation
2,176
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 12 33
Impact
~128k people reached

Apr
28
awarded  Autobiographer
Apr
12
awarded  Nice Question
Mar
14
reviewed Reviewed SQL Server using index scan instead of seek when updating a view that has an INSTEAD OF UPDATE trigger via a cursor
Mar
9
reviewed Approve SELECT DISTINCT TWO columns not ranged
Mar
9
answered SELECT DISTINCT TWO columns not ranged
Feb
26
awarded  Popular Question
Feb
24
asked What can cause an “SCD is not compatible with this version of the DataFlow” error?
Feb
23
reviewed Approve FIFO queue table for multiple workers in SQL Server
Feb
23
awarded  Popular Question
Feb
22
comment What is the sense and benefit of using SqlCommand.Prepare()?
"Yes, sir. Driver, prepare to move out." "What are you preparing?! You're always preparing! Just go!"
Feb
18
answered Is there a way to do the following query with joins instead of a sub query?
Feb
9
awarded  Nice Question
Feb
3
answered Ordering of a dimension in sql server datawarehouse
Dec
28
comment Database normalization: Which is the best fit?
What's the proposed schema for the unified child table?
Dec
18
awarded  Famous Question
Nov
28
awarded  Custodian
Nov
28
reviewed Approve Ctrl-F1 shortcut stopped working in SSMS 2014
Nov
12
comment How long is the output of EncryptByPassPhrase(), relative to the input?
That's exactly what I needed! I know it's usually bad form to accept an answer so soon, but this is a perfect answer.
Nov
12
accepted How long is the output of EncryptByPassPhrase(), relative to the input?
Nov
12
comment How long is the output of EncryptByPassPhrase(), relative to the input?
@srutzky: You are quite correct: the value had trailing spaces. I'd forgotten that SQL Server can store trailing spaces but doesn't report them with LEN.