Removing Duplicate Records from SQL Server Table

In recent few interviews there was a scenario that interviewer asked me to remove duplicate records from SQL Server table. For example: There is a table with 3 columns (COL1, COL2, COL3), having duplicate data stored like below screen shot of the table. If you can carefully look at the records you can find that […]

Read more โ†’

Static Constructors, Life time and Use

It’s a quick article. In a technial interview, panel has asked me about the static constructors and how and when static constructors will be called etc. He wrote a program to extract more idea from me through.  I recreated the program to explain about it. Before going further I will fill in details about STATIC constructors. A static […]

Read more โ†’