October 17, 2017

Deadlocks can be a serious plague to your existing systems. I am a fan of being proactive whenever  possible. So instead of waiting for complaints from users or application developers, and then having to dig through logs and extended events, we can setup some type of a...

June 21, 2017

 Not always optimal...

What is it?

Let’s say you have a parameterized proc, and it creates and caches an execution plan based on certain values for said parameters. It “sniffs” the parameters and uses that for cardinality estimation.

Then you run this stored proc again, b...

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
  • Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle