Snippets of the day – Thursday, January 30, 2014

Posted on Leave a commentPosted in Snippets

Here are some of the most recently published snippets! linux bash while statement script This is a very simple example of while statement in linux bin bash console. The while condition terminates after N iterations, printing a counter for each loop. Open the snippet Author:    lbottaro Transpose Query Output in SQL Server This script […]

Snippets of the day – Sunday, January 5, 2014

Posted on Leave a commentPosted in Snippets

Here are some of the most recently published snippets! Detect and received deadlock info on SQL Server The first requirement is to turn on the appropriate Trace Flags: DBCC TRACEON (3605,1204,1222,-1) The second requirement is to ensure you have DB Mail setup and working (optional). Many thanks to Geoff Albin: http://www.sqlservercentral.com/articles/deadlock/71374/ Open the snippet Author: […]

Snippets of the day – Thursday, December 19, 2013

Posted on Leave a commentPosted in Snippets

Here are some of the most recently published snippets! Find SQL Queries that can be improved This query makes use of the DMVs in order to find queries that could be tuned for better performance. You can alter the TOP clause to suit your needs. Thanks to Simon Osborne. http://www.sqlservercentral.com/scripts/T-SQL/99611/ Open the snippet Author:    […]