Category Archives: SQL Indexes

SQL Indexes

Interview question – Is Clustered index on column with duplicate values possible?

Posted on August 13, 2015 by vivekjohari

Through this article, we are going to discuss three important interview questions of SQL which are given below:-  1) Can we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key on a table on which a … Continue reading →

Posted in Interview Questions, SQL Advanced, SQL Indexes | Tagged , , , | Leave a comment

SQL Script to find the missing indexes

Posted on January 25, 2015 by vivekjohari

Script to find the missing indexes Performance tuning in SQL is important exercise and index creation is an important part of it. Sometimes base on the frequent SQL queries, we need to create some indexes or missing indexes which are enhance the … Continue reading →

Posted in DBA, SQL Advanced, SQL Indexes, SQL Server | Tagged , | 29 Comments

Script to find the Fragmentation of indexes

Posted on January 4, 2015 by vivekjohari

Script to find the Fragmentation in Indexes In my previous articles, Fragmentation in SQL Server and Rebuild And Reorganization of Indexes , we talk in detail about Index fragmentation and rebuild or reorganize the indexes. Below is the SQL script which we … Continue reading →

Posted in DBA, SQL Advanced, SQL Indexes, SQL Server | Tagged , | 33 Comments

Rebuild And Reorganization of Indexes

Posted on December 31, 2012 by vivekjohari

Rebuild and  Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert, Delete) in the tables. Over a period of time, the may causes the fragmentation on the table in which  the … Continue reading →

Posted in SQL Indexes, SQL Server | Tagged , | 31 Comments

Fragmentation in SQL Server

Posted on December 31, 2012 by vivekjohari

Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in understanding the fragmentation in SQL Server. It can be defined into two types1. Internal Fragmentation 2. External Fragmentation Internal Fragmentation:- … Continue reading →

Posted in SQL Indexes, SQL Server | Tagged , | 2 Comments

Indexes in Sql server

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Most Imp SQL Concepts, SQL Indexes, SQL Server | Tagged , | 25 Comments

Difference between Clustered Index and Non clustered Index

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Imp SQL Difference, Interview Questions, SQL Indexes, SQL Server | Tagged , , | 31 Comments