I optimize the speed, efficiency, and stability of SQL Server.
August 8, 2018
I wish page splits were delicious.
What are page splits?
Page splits occur when a data page gets filled with data and a new page is needed to make room for new data. There are times when data modification causes data to be inserted in the middle of a page, this causes...
November 7, 2017
This post is meant to be a quick primer on Table Partitioning in SQL Server.
What is it?
Let's say you have a large table that is accepting a lot of transactions, partitioning allows you to scale this particular table out into different (physical partitions). Thus sprea...
Forgot my SA password, and I don't have sysadmin rights...
December 10, 2018
Page Splits, should I worry?
Capture Query Information with Extended Events
July 30, 2018
DBCC CheckDB on a large Database
July 24, 2018
New TempDB TraceFlag
July 19, 2018
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)