I optimize the speed, efficiency, and stability of SQL Server.
July 19, 2018
In the past we're used to enabling Traceflags 1117 and 1118 in order to help with TempDB Contention. With the release of SQL 2016, these were no longer needed...however
Now it's been suggested to enable Traceflag 3427.
Why? Because a new type of contention has emerged c...
Forgot my SA password, and I don't have sysadmin rights...
December 10, 2018
Page Splits, should I worry?
August 8, 2018
Capture Query Information with Extended Events
July 30, 2018
DBCC CheckDB on a large Database
July 24, 2018
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.
High Availability (6)
Disaster Recovery (5)
Performance Tuning (12)
Professional Development (1)