Reputation
27,849
Next tag badge:
372/400 score
85/80 answers
Badges
5 51 92
Newest
 Good Answer
Impact
~1.3m people reached

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
Apr
24
answered How best to maintain SQL log file sizes
Apr
24
comment Rebuilding, truncating etc SQL Server 2008 maintenance
Let the DBA do these DBA tasks... (just my opinion)
Apr
23
comment Can I drop and recreate a system extended stored procedure?
+1 wish I could +10 this answer.