1,036 reputation
75
bio website all-are-wonders.blogspot.com
location Detroit, MI
age 46
visits member for 3 years, 6 months
seen Jul 17 at 13:46

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
Jan
7
comment How do I shrink all files quickly for all databases?
+1. Interesting blog post.
Jan
6
answered How do I shrink all files quickly for all databases?
Jan
5
answered Is there a performance gain by handling data with stored procedures versus feeding it into functions after retrieval?
Jan
5
answered Is this a new common pattern in Oracle Where exists ( Select NULL FROM…)?
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).