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

Autumn Update - Trick or Treat

Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving...

First thoughts on Power BI on premises

The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...

PASS Summit 2016 Wrapup

Last week I had one of the best experiences of my career – attending this year’s PASS Summit in Seattle. I...

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

Power BI Custom Visuals Class (Module 21 – Advanced Time Slicer)

In this module, you will learn how to use the Advanced Time Slicer Power BI Custom Visual.  The Advanced Time...

Power BI Custom Visuals Class (Module 23 – Sparkline)

In this module you will learn how to use the Sparkline Power BI Custom Visual.  The Sparkline allows you to...

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 Server DMA – Data Migration Assistant V2.0

One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...

SQL Server Infrastructure and Virtualization Boot Camp

I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our...