Skip to content

Instantly share code, notes, and snippets.

View mjswart-d2l's full-sized avatar

Michael J Swart mjswart-d2l

View GitHub Profile
@mjswart-d2l
mjswart-d2l / Repro.sql
Created August 22, 2017 17:19
Reproduction of poor SQL Server query plan choice
use master
go
IF db_id('MyTest') IS NOT NULL
BEGIN
ALTER DATABASE MyTest SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE MyTest;
END
CREATE DATABASE MyTest;