Skip to content

Instantly share code, notes, and snippets.

View adamfortuno's full-sized avatar
😁

Adam adamfortuno

😁
View GitHub Profile
@adamfortuno
adamfortuno / make_sandbox_parametersniffing.sql
Last active February 11, 2019 22:15
Strategies for Fixing Parameter Sniffing in SQL Server
---Create a playground
create database sandbox;
go
use sandbox
go
drop table dbo.tableOfThings
go
create table dbo.tableOfThings (
id int identity(1,1) not null constraint pk_tableOfThings primary key
, date_created datetime2 not null constraint df_date_created default getdate()
@adamfortuno
adamfortuno / coffee_analysis_db_create.sql
Created July 11, 2018 17:51
Coffee: Analytics Database and Queries
create database ae_analysis;
GO
USE ae_analysis;
GO
DROP TABLE IF EXISTS dbo.summary;
create table dbo.summary (
Test varchar(10) not null
, Cycle tinyint not null
, WorkloadID uniqueidentifier not null
, Hostname sysname not null