Reputation
1,416
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 9 20
Newest
 Curious
Impact
~135k people reached

Jun
26
comment How to compare two SQL Server 2008 configurations
I know, that's why just a comment as additional info to your answer. Usually you got 80% default settings. So this way you're left to compare only the remaining 20%. (+1 btw)
Jun
26
awarded  Commentator
Jun
26
comment How to compare two SQL Server 2008 configurations
Check out the script at sqlserverperformance.idera.com/uncategorized/… to quickly spot non-default settings for SQL Server 2008.
Jun
20
revised Where is this mystery trace going (SQL Server 2000)?
added quote
Jun
20
answered Where is this mystery trace going (SQL Server 2000)?
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
9
comment Is Index causing timeouts?
As soon as the first column in your index is not used in your query, the index cannot be efficiently used. Also, maybe you deleted some indexes that were crucial for some queries that now time out. I once had better performance using single indexes for each query column instead of a large combined one (stackoverflow.com/q/702469/44522).
Feb
17
comment Why can't I connect to SQL Server 2008?
Your SQL Server Browser service is maybe not running. See my checklist in this answer: stackoverflow.com/a/6001023/44522
Jan
6
awarded  Enlightened
Jan
6
awarded  Nice Answer
Nov
29
accepted Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
Nov
29
revised Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
added 99 characters in body
Nov
29
asked Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
Oct
24
answered Connection To R2 Named Instance
Oct
10
awarded  Enthusiast
Oct
6
revised Improving the performance of a long query
added 55 characters in body
Oct
6
answered Improving the performance of a long query
Oct
5
comment SQL Server 2005 database engine login failed error?
Just accept the answer, if it helped you.
Oct
5
revised SQL Server 2005 database engine login failed error?
added 181 characters in body