Reputation
28,360
Next tag badge:
93/100 score
25/20 answers
Badges
5 54 95
Newest
 Nice Answer
Impact
~1.5m people reached

May
15
comment Cannot connect to SQL Server after setting sa password to blank
That's a named pipes error. And, I'll stress like those commenting before me: that is a terrible practice to have a blank sa password. That's about as egregious as it gets for security vulnerabilities.
May
13
awarded  Caucus
May
11
comment Restore database with zero size log file
+1 this is the right answer.
May
10
comment Concurrent Access causing deadlock on the same table
Agreed with @StrayCatDBA. We need the entire deadlock graph, there isn't enough information to determine root cause.
May
7
revised Selective Xml Indexing
edited title
May
7
answered Is it possible to validate DML statements?
May
7
comment Is it possible to validate DML statements?
Which RDBMS are you working with? SQL Server?
May
7
answered How do I check if a certain SQL statement is being run?
May
2
comment Restoring differential backup from SQL Server 2005 to SQL Server 2012
Somebody took a full backup (without specifying WITH COPY_ONLY) on the database since the full backup that you have onhand was taken.
May
2
revised CPU column 5x higher on one machine vs another?
edited title
May
2
comment CPU column 5x higher on one machine vs another?
Just because the queries are the same, doesn't necessarily mean the plans are and what operations are taking place. Have you capture the actual execution plans from both environments to compare?
May
2
answered SSMS 2012 is not showing the tables of the system databases
May
2
comment SSMS 2012 is not showing the tables of the system databases
connect.microsoft.com/SQLServer/feedback/details/773184/…
Apr
29
comment Upgrade SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard
Why don't you just do a side-by-side and then migrate all databases and server objects?
Apr
26
comment Total Memory capped far below available memory
@Kin "maximum server memory is set to the default"
Apr
26
revised Total Memory capped far below available memory
added 34 characters in body; edited title
Apr
25
revised Transactional Replication Concerns
deleted 11 characters in body
Apr
25
comment Transactional Replication Concerns
@user23025 Glad to help. If you have any other questions regarding this, please feel free to ask. But if I've answered your question to your satisfaction, please mark this answer as correct.
Apr
25
awarded  Notable Question
Apr
25
answered Transactional Replication Concerns