Home » Tutorials » SQL SERVER » Archive by categorySql Server Scripts

Find most used column names in database – Sql Server

Find most used column names in database Query: [crayon-5cba66f02ca9c646459494/]   Columns Description: ColumnName – column name Tables – number of tables that have particular column name PercentTables – percentage of tables with column with that name   Sample Output of  AdventureWorks2017:
Continue reading

Find Most Expensive Stored Procedure Sql Server

Problem: An important step in optimizing a system is to take a holistic approach and look at stored procedures that are called very often. These procedures can often be the backbone of a system. Sometimes optimizing these procedures can have a dramatic effect on relieving the physical bottlenecks...
Continue reading

Analyse Missing Index Sql Server

Analyse Missing Index Sql Server- Script 1 [crayon-5cba66f02e730000880956/]   Analyse Missing Index Sql Server- Script 2 [crayon-5cba66f02e737861933188/] I request you to run both scripts in your testing environment and verify and then run to Analyse Missing Index in Sql Server.  
Continue reading

The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.