MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about detecting unused Indexes in SQL Server. In SQL Server, in some cases, you may want to detect unused Indexes. You can easily do this using the code below. SELECT o.name AS ObjectName, i.name AS IndexName, i.index_id AS IndexID,...
Hello to everyone, In this article, I will try to give information about finding Fragmentation rates of Indexes in SQL Server. In SQL Server, in some cases, you may want to find the Fragmentation rates of Indexes. You can easily do this using the code below. SELECT ps.object_id, i.name AS...
Hello to everyone, In this article, I will try to give information about listing indexes linked to tables in SQL Server. In SQL Server, in some cases, you may want to list the indexes that are linked to the tables. You can easily do this using the code below. SELECT...
Hello everyone, In this article, I will try to give information about finding Unused Index values in SQL Server. In SQL Server you may want to find unused Index values in some cases. You can easily do this by using the script below. SELECT TOP 25 o.name AS ObjectName, i.name...
Hello everyone, In this article, I will give information about listing all the indexes in the database in SQL Server. In SQL Server, in some cases, we may want all index values in the database to be listed. You can easily do this with the help of the code below....