Skip to content

Instantly share code, notes, and snippets.

@peterkruis
peterkruis / BrentOzar20240222PX
Created February 22, 2024 18:20
BrentOzar20240222PX
/*Drop and create indexes*/
EXEC DropIndexes;
GO
CREATE INDEX CreationDate ON dbo.Users (CreationDate);
CREATE INDEX Reputation ON dbo.Users (Reputation);
/*Define end date for last 90 days*/
SELECT TOP (1)
CreationDate
FROM dbo.Users