Reputation
27,594
Next tag badge:
364/400 score
84/80 answers
Badges
5 48 91
Newest
 Nice Answer
Impact
~1.2m people reached

May
15
comment Running a query within a scheduled job
@Vince There's actually a pretty good example of this on TechNet. See this link all the way at the bottom titled Sending an HTML e-mail message (technet.microsoft.com/en-us/library/ms190307.aspx).
May
15
answered Running a query within a scheduled job
May
15
comment Running a query within a scheduled job
The query by itself is just fine. Can you post the actual scripted command you are using to create the job as well as the mail send command? My guess is you're having quoting issues.
May
15
revised Running a query within a scheduled job
added 45 characters in body
May
15
revised Suspended in index rebuild
added 86 characters in body
May
15
answered Suspended in index rebuild
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?