Use of Private Constructor in C# Hey folks, till day you have read Difference between Throw and Throw ex in C#, Difference
Difference between Throw and Throw ex in C# | Throw vs Throw ex in C#
Difference between Throw and Throw ex in C# Hey folks, till day you have read Difference between Var and Dynamic
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
010. Generate CREATE Index script for all indexes in database in Sql Server
Problem: Sometime DBA’s want to get script of indexes from their current database. How anyone can get “Drop and Create
Get YouTube video thumbnail – YouTube API
Get YouTube video thumbnail – YouTube API Each YouTube video has 4 generated images. They are predictably formatted as follows:
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
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