Reputation
1,166
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
10 7
Newest
 Caucus
Impact
~93k people reached

  • 0 posts edited
  • 1 helpful flag
  • 72 votes cast
Feb
5
comment GROUPING BY multiple columns/reqs
Which RDBMS are you using? MSSQL added a PIVOT operator in the 2005 version.
Jan
14
comment Passing array parameters to a stored procedure
How are you getting the big list of IDs?
Jan
14
comment SQL Server Management Studio for a remote database
It wasn't until I read the first answer that I realized I was assuming you would use a VPN.
Jan
11
comment How do you document your databases?
+1 for extended properties
Jan
10
comment How can I tell WHY an insert on a certain table is slow?
Do you have autoexpand enabled on your data files? That can cause performance problems with the default configuration.
Jan
7
comment How do I shrink all files quickly for all databases?
+1. Interesting blog post.
Jan
5
comment Does it make sense to use SQL Server's bracket notation in hand written code?
I don't agree that leading commas are more readable, unless you mean by more readable that they stick out like sore thumbs (which is my objection to them).