Find most used column names in database Query: select col.name as ColumnName, count(*) as Tables, cast(100.0 * count(*) / (select
Tag: Sql server helping Script
004. Find most expensive queries-Sql Server
———********* Most expensive queries starts****** ———— SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset
009. Find unused Indexes – Sql Server
—– ************ Unused Index Script Starts********———- SELECT TOP 25 o.name AS ObjectName , i.name AS IndexName , i.index_id AS IndexID
008. Find redundant indexes Sql Server
————****** Script to find redundant indexes *********——- ;WITH MyDuplicate AS (SELECT Sch.[name] AS SchemaName, Obj.[name] AS TableName, Idx.[name] AS
001. Select Primary Key value from Table dynamically-Sql Server
Select Primary Key value from Table dynamically Hello friends, Today I am going to teach select primary key value from
005. Find most expensive tables-Sql Server
—– ************ Find most expensive tables Starts ****** ————– Select Object_Name(ix.[object_id]) as objectName , Sum(ddius.user_seeks) As ‘table_seeks’ , Sum(ddius.user_scans)
002. Find Blocking queries in Sql Server
Find Blocking queries in Sql Server Hello folks, today I will explain regarding most common problem of blocking in Sql