Difference between Throw and Throw ex in C# Hey folks, till day you have read Difference between Var and Dynamic
Category: Interview Q&A
Interview Q&A
Use of Yield in C#
Use of Yield in C# Quote from MSDN “The yield keyword signals to the compiler that the method in which
003. 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
Enumerate Enum C# with Examples
How to enumerate Enum C# Problem: We have enum declared in our class and we want to enumerate enum. How could
Difference between Hashtable and Dictionary
Difference between Hashtable and Dictionary Hey readers, till day you have read Insert data into Database table using SQLBulkCopy class in
135. Remove Cross duplicate rows in SQL SERVER
Remove Cross duplicate rows in SQL Server Hello friends, I got one question from my friend who recently appeared for
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
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