———********* 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)
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
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
Remove blank lines in Sql Server Script
Remove blank lines in Sql Server Script Problem: Let’s say we have a script in which there are blank lines
Difference between Nullable<> and ?
Difference between Nullable<> and ? Hello friends, till now I have explained regarding different differences between. So I recommend you
Difference between String and string in C#
Difference between String and string string is an alias in C# for System.String. So technically, there is no difference. It’s
Difference Between WCF and WebAPI
Hello folks, hope you all are doing well. Today I want to explain regarding difference between WCF and Web API
Find Postback control of Page in asp.net
Find Postback control of Page in asp.net Problem: Let’s say your page has been posted back and you want to find