If you are running SQL Server jobs with numerous steps there can be failures due to network glitches or deadlocks. In such a scenario the DBA will typically restart the job from the failed step. However, there is an option in SQL Server Agent to automatically retry the job, which is under utilized by many DBAs. This faq will tell you how to do it.
Thursday, November 22, 2012
Sunday, November 18, 2012
The latest SP1 has many new and enhanced features.
Few are following,
Selective XML Index
DBCC SHOW_STATISTICS works with SELECT permission
New function returns statistics properties - sys.dm_db_stats_properties
Download 1GB (!!!) size of SP1 from here.