Tags » SQL Index

Interview Question of the Week #039 - What is Included Column Index in SQL Server 2005 and Onwards?

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at… 397 more words

SQL Authority

Interview Question of the Week #021 - Difference Between Index Seek and Index Scan (Table Scan)

Question: What is the difference between Index Seek and Index Scan?

Answer: Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. 244 more words

SQL Authority

Create a SQL index


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

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