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

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-technothirsty
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




DISCLAIMER:
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.