I optimize the speed, efficiency, and stability of SQL Server.
Forgot my SA password, and I don't have sysadmin rights...
Page Splits, should I worry?
Capture Query Information with Extended Events
DBCC CheckDB on a large Database
New TempDB TraceFlag
WHO AM I ?
My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.
Does SQL Server need more memory? Page Life Expectancy
Use Cases for Query Store
Query Store Overview
Clear cache for a single Stored Procedure
Using Diskspd To Test Storage
Reading the Deadlock Graph