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
1d
awarded  Caucus
Feb
5
comment GROUPING BY multiple columns/reqs
Which RDBMS are you using? MSSQL added a PIVOT operator in the 2005 version.
Jan
3
awarded  Yearling
Dec
26
awarded  Autobiographer
Nov
21
awarded  Good Answer
Aug
29
awarded  Guru
Jan
3
awarded  Yearling
Jan
3
awarded  Yearling
Jun
16
awarded  Good Answer
Mar
14
awarded  Enlightened
Mar
14
awarded  Nice Answer
Jan
3
awarded  Yearling
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
12
awarded  Citizen Patrol
Jan
12
awarded  Enlightened
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
10
answered Where should one put indexes in a time dimension table?
Jan
10
awarded  Beta