1,136 reputation
106
bio website all-are-wonders.blogspot.com
location Irving, TX
age 47
visits member for 4 years, 2 months
seen Mar 24 at 13:40

I haven't played competitively since high school and am preparing to get back into it.


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
Jan
9
answered Performance implications of MySQL VARCHAR sizes