Home » Tutorials » Archive by categorySQL SERVER

Find most used column names in database – Sql Server

Find most used column names in database Query: [crayon-5cba67030e65b396427757/]   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

Remove Cross duplicate rows in SQL

Desired OUTPUT Query-3
  Remove Cross duplicate rows in SQL Hello friends, I got one question from my friend who recently appeared for an interview, that how to remove cross duplicate rows in SQL.? So I was looking for a solution but after many failures I got correct solution. Let you...
Continue reading

Analyse Missing Index Sql Server

Analyse-Missing-Index-Sql-Server-technothirsty
Analyse Missing Index Sql Server- Script 1 [crayon-5cba6703104ab367993033/]   Analyse Missing Index Sql Server- Script 2 [crayon-5cba6703104b3286840571/] 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.