Viewing 6 posts - 1 through 6 (of 6 total)
Check out Benjamin Nevarez if you're still pursuing this. I had several exchanges with him a while back about how calculations were derived by the optimizer. This knowledge...
June 17, 2011 at 4:58 pm
Reducing MaxDop is a classic internet text book/bandaid response which 99.999% results in unacceptable results. If you're messing with maxdop, then I'd say you're short on experience and plenty...
June 5, 2010 at 8:44 pm
I had the same issue with sp_send_dbmail and the @query parameter called from a SQL job. I could successfully execute sp_send_dbmail/@query param' from the Query Analyzer but it would fail...
February 10, 2010 at 3:58 pm
I had the same issue with sp_send_dbmail and the @query parameter called from a SQL job. I could successfully execute sp_send_dbmail/@query param' from the Query Analyzer but it would...
February 10, 2010 at 3:15 pm
It's possible that a transaction would block the DDL and, therefore, create blocking. This could be a nail biter if the table is really "hot" such as an "Order"...
May 19, 2009 at 3:12 pm
My 64bit SQL 2005 Cluster can go AWOL on a specific queries. 100% CPU, IO and CPU at a virtual stand-still, and SOS_SCHEDULER_YIELD dominates exclusively. No real work...
October 1, 2008 at 6:40 pm
Viewing 6 posts - 1 through 6 (of 6 total)