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

Select Primary Key value from Table dynamically-Sql Server

Select-Primary-Key-value-Table-dynamically-Sql-Server-technothirsty
Select Primary Key value from Table dynamically Hello friends, Today I am going to teach select primary key value from any table dynamically. At the time development we need primary key many times so no need to create another stored procedure.Below store procedure help to find out primary...
Continue reading

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 add some tables in that database with some sample data and then we will major fragmentation level as well size of database & log. After that we will...
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.