1,076 reputation
95
bio website all-are-wonders.blogspot.com
location Irving, TX
age 47
visits member for 3 years, 11 months
seen Dec 4 at 17:48

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
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?