Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Archives: August 2012

Suppressing namespace attributes in nested select statements when using FOR XML workaround

I was helping out on the forums the other day with a user who had stumbled across the quirk of SQL putting in an excessive amount of namespace declarations when using nested select statements as part of a FOR XML statement. There is a connect item already open for this,… Read more

0 comments, 905 reads

Posted in SQL Server Rocks! on 28 August 2012

Script to find orphaned/unreachable job steps within your SQL jobs

SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created by allowing great flexibility with the scheduling, execution, flow actions and notifications. Invariably, when jobs are setup, they just run and run without many problems, but the other day I… Read more

0 comments, 873 reads

Posted in SQL Server Rocks! on 23 August 2012