Here is the table I used, very simple:
CREATE TABLE dbo.Wait_Type_Description
(
Wait_type VARCHAR(50) NOT NULL,
Wait_Type_desc VARCHAR(8000) NOT NULL
)
and I am joining it like this, again super simple example:
SELECT *
FROM sys.dm_exec_requests der
JOIN dbo.wait_Type_description wtd
ON der.wait_type = wtd.wait_type
FROM sys.dm_exec_requests der
JOIN dbo.wait_Type_description wtd
ON der.wait_type = wtd.wait_type
All 345 INSERT statements can be found here, sorry this is obnoxious to look at you may download the script or cut and paste it below.
No comments:
Post a Comment