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