SQL Indexes Archives - Technology with Vivek Johari

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

August 13, 2015January 31, 2019 vivekjohariLeave a Comment

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 clustered index is already defined? 3) If a clustered index is already defined on a […]

SQL Script to find the missing indexes

January 25, 2015October 6, 2018 vivekjohari29 Comments

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 query performance. Below script will help in finding the missing indexes. SELECT db_name(d.database_id) dbname , object_name(d.object_id) […]

Script to find the Fragmentation of indexes

January 4, 2015October 6, 2018 vivekjohari33 Comments

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 can use to find the Fragmentation in Indexes created on the database. SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level, […]

Rebuild And Reorganization of Indexes

December 31, 2012October 7, 2018 vivekjohari31 Comments

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 logical ordering based on the key value pairs does not match with the physical ordering inside the data […]

Fragmentation in SQL Server

December 31, 2012December 6, 2020 vivekjohari2 Comments

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:- In this fragmentation, there exists a space between the different records within a page. This […]

Indexes in Sql server

January 3, 2010February 1, 2019 vivekjohari25 Comments

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 particular record. In Sql Server there are two types of Index 1) Clustered Index 2) […]