Tags » SQL Index

SQL SERVER - Mistake to Avoid: Duplicate and Overlapping Indexes - Notes from the Field #073

: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about indexes and its impact. We often believe that indexes will improve the performance of the query, but it is not true always. 1,028 more words

SQL Authority

SQL SERVER - COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression

In earlier blogs on “Fundamentals of Columnstore Index”, I took a simple approach on taking a tour of how to create a simple Columnstore index. 489 more words

SQL Authority

How to identify unused indexes in SQL Server

We can use dynamic management view “sys.dm_db_index_usage_stats” to identify unused indexes on SQL Server.

DMV – sys.dm_db_index_usage_stats

This DMV shows you how many times the index was used for user queries. 294 more words

Advanced SQL

SQL SERVER - What is Hypothetical Indexes?

If you ever thought this is some sort of trick to bring you to the blog, well you are wrong. This infact is something worth a look and interesting thing to know. 803 more words

SQL Authority

SQL SERVER - GIDS - Two Technical Sessions Today - Resources and Whereabouts - Part 2

Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today.

If you are not going to attend this event, sign up for the newsletter over here:  474 more words

SQL Authority

SQL SERVER - GIDS - Two Technical Sessions Today - Resources and Whereabouts

Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today.

If you are not going to attend this event, sign up for the newsletter over here:  469 more words

SQL Authority