• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

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...

July 30, 2018

Many of us have not made the effort to switch from profiler to Extended events.  It's 2018, if you haven't found a few hours to learn about this incredibly powerful tool, I urge you to do so now. 

I'm going to provide a quick means of tracking queries with extended...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

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.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle