CLUSTERED Archives - Steve Stedman

SQL Sunday Fun – Word Search with SQL Server Keywords

By SteveStedman Posted on August 11, 2013 Posted in TSQL No Comments Tagged with CLUSTERED, OPENDATASOURCE, OPENROWSET, OPTION, PRIMARY, RETURN, RIGHT, WAITFOR

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 »

Query To Simulate CPU Load

By SteveStedman Posted on June 13, 2013 Posted in CTE 5 Comments Tagged with CLUSTERED, CPU, GO, Resource Governor, SQL Server, UNIQUEIDENTIFER, UNIQUEIDENTIFIER, VM

Quite often when working testing different performance measures from the Database Health Reports to testing Resource Governor configuration I end up in a situation where I need to emulate a high CPU load on my test SQL Server. In this case it is usually my desktop or a Hyper-V virtual machine, where I want to see how things will work …

Query To Simulate CPU Load Read more »

Tag: CLUSTERED

SQL Sunday Fun – Word Search with SQL Server Keywords

Query To Simulate CPU Load

Login