Reputation
107,586
Next tag badge:
134/100 score
15/20 answers
Badges
11 182 311
Newest
 Nice Answer
Impact
~5.4m people reached

8h
comment Does Trace Flag 8295 applies to SQL Server 2012?
It seems like the bug was fixed after 2008 R2, and I'm not sure that it addresses a sort warning specifically anyway.
9h
revised In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?
added 230 characters in body
10h
awarded  Nice Answer
14h
answered In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?
18h
comment Howto query all files, their fill level and additional drive info with one query?
@Magier Probably not, I wasn't evaluating that part at all.
19h
answered Howto query all files, their fill level and additional drive info with one query?
21h
answered Why set Auto Update Statistics to False?
1d
awarded  Enlightened
1d
awarded  Nice Answer
May
2
comment Create update Trigger
Did they give a reason? Did they explain how an explicit join is different from table, table except that the latter makes a cross join possible (and which is what you have here, though this is rarely the intention).
May
2
comment Create update Trigger
The first issue with your trigger logic is that it assumes that all insert or update operations will affect exactly one row. You need to join your base tables to inserted rather than assign individual values to variables, otherwise your trigger operations will only work on one arbitrary affected row. Also, while not deprecated, explicit INNER JOIN syntax is generally preferred over the old-style table1, table2 syntax.
May
1
revised Security concerns on SMTP in SQL Server
deleted 117 characters in body
May
1
comment Are cursors/While loops the only way to make administrative changes to multiple databases?
And yes, you're being paranoid about performance. Any maintenance you need to do against every database has to be done one by one, it doesn't matter how you get there - while loop, cursor, what have you.
May
1
comment Are cursors/While loops the only way to make administrative changes to multiple databases?
A while loop is a cursor. I'm not sure where the mindset that a while loop is faster than a cursor comes from; I'm sure there are cases where this is true, when the while loop is firehose and the cursor is over-engineered, but in most cases if you've coded them correctly they are identical.
Apr
30
revised SQL Row concatenation with XML PATH and STUFF giving aggregate sql error
added 178 characters in body
Apr
30
revised SQL Row concatenation with XML PATH and STUFF giving aggregate sql error
added 401 characters in body
Apr
30
comment Restore a database with compression on a non-enterprise edition SQL Server
@user193130 Yes, you'd have to generate the BCP or other scripted data from the original source or a successful restore of your backup. That won't happen on Standard Edition. Just drop the suspect database that resulted from your attempt.
Apr
30
revised SQL Row concatenation with XML PATH and STUFF giving aggregate sql error
edited body
Apr
30
revised SQL Row concatenation with XML PATH and STUFF giving aggregate sql error
added 2 characters in body; added 146 characters in body
Apr
30
answered SQL Row concatenation with XML PATH and STUFF giving aggregate sql error