Category: Indexes

  • Sql Server Index

    Indexes in sql server Part 35 C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists In this video we will learn about What … Clustered vs. Nonclustered Index Structures in SQL Server Clustered and nonclustered indexes share many of the same internal structures, but they’re fundamentally different in nature. Watch Microsoft…

  • SQL DBA Cheatcode Part 5 : Playing with indexes

    SQL DBA Cheatcode Part 5 : Playing with indexes

    Hello Readers, Today, I am trying to put down few but very useful index related scripts. I have used these scripts many times with different versions of SQL Server. 1. Missing Index : Missing indexes are one reason why an SQL query takes longer (much longer) to complete. Here’s how to find out about them and…

  • SQL DBA Cheatcode Part 4 : Few Important Queries for any DBA

    SQL DBA Cheatcode Part 4 : Few Important Queries for any DBA

    Dear Readers,   I am back with part 4 of Cheatcode series after gap of almost one month. In First three Parts of this series I covered, Few Generic Scripts, Replication Specific Scripts & Database Backup\Restore Specific Scripts.   In this Series, I try to cover those Scripts which we can use in our day…

  • March towards SQL Server : Day 28 – SQL DBA Interview Questions Answers – All About Indexes – Part 2

    March towards SQL Server : Day 28 – SQL DBA Interview Questions Answers – All About Indexes – Part 2

    Here goes another post on Indexes. I hope you read my previous post on Indexes. If not, you may quickly go through. SQL DBA interview questions and answers on Indexes Part 1 1. What are the Advantages of Indexes? Query optimization: Indexes make search queries much faster. Uniqueness: Indexes like primary key index and unique…

  • March towards SQL Server : Day 27 – SQL DBA Interview Questions Answers – All About Indexes

    March towards SQL Server : Day 27 – SQL DBA Interview Questions Answers – All About Indexes

    Lets not forget to talk about our ‘best friend’ for performance – Indexes. I know this is redundent information but the whole idea is to collect everything at one place. 1. What is an Index? A database index is a data structure that improves the speed of data retrieval operations on a database table at…