Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can…
SQL Script to find the missing indexes
Script to find the missing indexes Performance tuning in SQL is important exercise and index creation is an important part…
Script to find the Fragmentation of indexes
Script to find the Fragmentation in Indexes In my previous articles, Fragmentation in SQL Server and Rebuild And Reorganization of…
Rebuild And Reorganization of Indexes
Rebuild and Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,…
Fragmentation in SQL Server
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in…
Indexes in Sql server
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval…
Difference between Clustered Index and Non clustered Index
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval…