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 it appears is an iterator block. The compiler generates a class to implement the behavior that is expressed in the iterator block. In the iterator block, the yield...
Continue reading

Get YouTube video thumbnail – YouTube API

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:<insert-youtube-video-id-here>/0.jpg<insert-youtube-video-id-here>/1.jpg<insert-youtube-video-id-here>/2.jpg<insert-youtube-video-id-here>/3.jpg The first one in the list is a full size image and others are thumbnail images. The default thumbnail image (ie. one of 1.jpg,...
Continue reading

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

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 we enumerate enum let’s together try to understand. Sometimes we get error message like “Enum is a type but used as a variable”. So how can we overcome...
Continue reading

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 C#, Ping in C# , Call method after specific time interval C#, Insert Retrieve images from Database in LINQ TO SQL, Compare two objects in C# and datakey from GridView RowCommand. Today we will...
Continue reading

Remove Cross duplicate rows in SQL

Desired OUTPUT Query-3
  Remove Cross duplicate rows in SQL Hello friends, I got one question from my friend who recently appeared for an interview, that how to remove cross duplicate rows in SQL.? So I was looking for a solution but after many failures I got correct solution. Let you...
Continue reading

Analyse Missing Index Sql Server

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

The content is copyrighted to and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.