Use of Yield in C#

Use-of-Yield-Keyword-in-C-sharp
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: https://img.youtube.com/vi/<insert-youtube-video-id-here>/0.jpg https://img.youtube.com/vi/<insert-youtube-video-id-here>/1.jpg https://img.youtube.com/vi/<insert-youtube-video-id-here>/2.jpg https://img.youtube.com/vi/<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

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

Enumerate-Enum-C#
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
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 asp.net 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-technothirsty
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




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.