Skip to Content

Performance Posts

T-SQL Window Functions

Posted July 10, 2017

By

I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which... more »
0

Getting Excited about my Practical Performance Monitoring Pre-Con

Posted July 02, 2017

By

  I was working on the demo’s for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I... more »
0

Logging wait stats over time

Posted June 08, 2017

By

We all know how valuable wait statistics can be when doing performance analysis. One thing I feel is missing in SQL Server is a trail of various... more »
0

Explaining Activity Monitor

Posted February 16, 2017

By

This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already.... more »
5

This month’s T-SQL Tuesday post

Posted January 09, 2017

By

…is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead... more »
1

This month’s T-SQL Tuesday post

Posted January 09, 2017

By

…is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead... more »
1

This month’s T-SQL Tuesday post

Posted January 09, 2017

By

…is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead... more »
1

SQL Nexus 5.5.0.1

Posted November 20, 2016

By

  The SQL Nexus set of utilities are some of the most under utilized tools available to the SQL Server community. I used and touted the RML utility for... more »
0

Misconceptions on parameter sniffing

Posted November 02, 2016

By

In my previous post, I explained the basic of parameter sniffing, and then built on that to explain the lesser known mechanics of variable sniffing and... more »
4

The sniffing database

Posted October 23, 2016

By

Your SQL Server instances, like people with hay fever that forget to take their antihistamines during summer, is sniffing all the time. Sniffing is a trick... more »
0