Problem: An important step in optimizing a system is to take a holistic approach and look at stored procedures that
Category: Performance Improvement in SQL
080. Analyse Missing Index Sql Server
Analyse Missing Index Sql Server- Script 1 /* [Date of Creation]: 08/20/2017 [Contact]: technothirsty@gmail.com */ SELECT TOP 100 PERCENT DB_NAME()
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
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)
Should we Shrink database – Sql Server
Should we Shrink database – Sql Server Lets try to understand with an example. First we will create database and
Rebuild and Reorganize Indexing Sql Server Scripts
Rebuild and Reorganize Indexing Sql Server Scripts Hello Folks, today I will explain regarding when and why we should Rebuild