Home » Posts taggedSql server helping Script

Find most used column names in database – Sql Server

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

Select Primary Key value from Table dynamically-Sql Server

Select-Primary-Key-value-Table-dynamically-Sql-Server-technothirsty
Select Primary Key value from Table dynamically Hello friends, Today I am going to teach select primary key value from any table dynamically. At the time development we need primary key many times so no need to create another stored procedure.Below store procedure help to find out primary...
Continue reading

Find Blocking queries in Sql Server

Find-blocking-queries-Sql-Server-technothirsty
Find Blocking queries in Sql Server Hello folks, today I will explain regarding most common problem of blocking in Sql Server. There are so many developers having same question “How can we find blocking queries in Sql Server”. Let’s try to take an example and understand how to...
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.