Tags » SQL Index

Create a SQL index

Issue.

SQL Timeouts on ORDER BY in a SQL query.

A very simple query I was working on kept timing, the query had an ORDER BY on one of the columns, after a short while of googling I ended up having to create an index on the table I  was running the query against. 78 more words

SQL Inserts

Find Index on a table in SQL Server

In this blog we will see how to find indexes on a table.

I have an employee table in my database.

Let us check the content in the table. 41 more words

SQL Server

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