Tag: WAITFOR

By Posted on Posted in TSQL No Comments Tagged with , , , , , , ,

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET OPENXML OPTION OVER PIVOT PRIMARY PROCEDURE RAISERROR RECONFIGURE REPLICATION RESTORE RETURN RIGHT ROLLBACK ROWCOUNT SELECT SET STATISTICS THEN TRAN TRANSACTION …

SQL Sunday Fun – Word Search with SQL Server Keywords Read more »

By Posted on Posted in Database Health No Comments Tagged with , , ,

The Waits Types page has been updated on the T-SQL Wiki. The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download).  Below is a screenshot of the Historic Waits Query Advisor in the Database Health Reports project. Here is the current list of waits that have documentation available.  

By Posted on Posted in Database Health No Comments Tagged with , , , , , , ,

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing waits. Here is an example, the following ugly block of TSQL updates a table with a few million rows in …

Beta 3 is Now Available. Read more »