SQL Create table waitstats

SQL

Download (.zip)

CREATE TABLE waitstats
(
wait_type      varchar(20),
requests       numeric(10, 0),
wait_time      numeric(12, 2),
signal_wait    numeric(12, 0),
recorded_time  datetime DEFAULT GETDATE()
)
GO

INSERT INTO waitstats (wait_type, requests, wait_time, signal_wait)
    EXEC ('DBCC SQLPERF(WAITSTATS)')

SQLCorrelated subquery with derived table Creat table nc heap nodupes Creat table nc nodupes
SQLCreat table nc overlap Create simple trace Create table clustered dupes
SQLCreate table clustered nodupes Create table waitstats Create view one two
SQLDelete from clustered table Locks for table creation Proc count tables
SQLRelated tables Repeatable read mode sp_EstTableSize