Reputation
28,205
Next tag badge:
92/100 score
25/20 answers
Badges
5 53 93
Newest
 Enlightened
Impact
~1.4m people reached

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
Apr
25
revised Transactional Replication Concerns
edited tags
Apr
25
comment Troubleshoot Microsoft SQL Server Reporting Services unexpected error
Check the logs for specific details on the error(s).
Apr
24
revised How best to maintain SQL log file sizes
added 3 characters in body