Home » Tutorials » SQL SERVER » Archive by categoryPerformance Improvement in SQL

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-5b74075147fc4900029485/]   Analyse Missing Index Sql Server- Script 2 [crayon-5b74075147fcb448516991/] 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

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 add some tables in that database with some sample data and then we will major fragmentation level as well size of database & log. After that we will...
Continue reading

Rebuild and Reorganize Indexing Sql Server Scripts

Rebuild-Reorganize-Indexes-1
Rebuild and Reorganize Indexing Sql Server Scripts Hello Folks, today I will explain regarding when and why we should Rebuild or Reorganize Index in Sql Server regularly. There is a simple rule behind Rebuild and Reorganize indexes which is shown in MSDN as below:   See as per MSDN when avg_fragmentation_in_percent’s...
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.