Thursday, November 22, 2012

Automatically Retry A SQL Server Job After A Failed Step

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.

Sunday, November 18, 2012

SQL Server 2012 SP1 is released

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.