Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the...

A Data Professional’s Story – PASS Summit 2016

This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...

Query Store custom SSMS performance dashboard

As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....

New indexes, hypothetically

I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...

Trick or Treat...Have I got an IT Training treat for you...

It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...

SQL Server DMA v2.0 – Migration Time

In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...

SQL : How to Find Unused Indexes details

The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track  index usage details of the database. This DMV gives an information about...

SQL Split String Function (STRING_SPLIT in 2016)

* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference

As a SQL Server developer you are often faced with the need to...

SQL Split String Function (STRING_SPLIT in 2016)

* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference

As a SQL Server developer you...

PASS Summit Announcements: Azure Analysis Services

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...