The Dictionary(Of TKey, TValue) and ConcurrentDictionary(Of TKey, TValue) provides same functionality like Hashtable. But a Dictionary(Of TKey, TValue) of a specific type (other than Object) provides better performance than a Hashtable for value types. Thi

Sometimes while writing a query, we might have the requirement of dynamic sorting, i.e. sorting based on different column based on certain conditions. To do this often developers will use dynamic queries. Without resorting to Dynamic queries, we can writ

Often in web applications, while displaying some data, we often pad data with some characters for uniform look. Suppose, to display dates in a combo box, we might want to display them as 00,01,02...30. Similarly in a numeric box with range 1 to 100, we mi

This is a real bug I first introduced in my SP and then spent two rounds before fixing, so I thought I'd post it. I had the following code in my SP [code] declare @Log_no int EXECUTE get_unique_key2 'K_GST_ACTV', @NumberOut = @Log_no OUTPUT; se

KEEPIDENTITY applicable only in an INSERT statement when the BULK option is used with OPENROWSET. Specifies that the identity value or values in the imported data file are to be used for the identity column. If KEEPIDENTITY is not specified, the identity v

My team mate was working with legacy code. Code used ISNULL and NULLIF functions, he got confused becauase of similar name. Thought of sharing with you all. ISNULL - Replaces NULL with the specified replacement value. NULLIF - Returns a null val

CPU load is goes 100% it create a problem to run application so overcome this issue .Net 4.5 Introduce new setting like percentCpuLimit We can Set this setting in web.config. The default value of the setting is 99%. To disable the throttling, set percen

What if you want to find out if a specific field contains a certain value? For example you want to find out all employees who have 0 vacation hours and 0 sickhours. Common way is to write a where clause with 'or'. Another way to do this is to use 'in'

Goto www.google.com, type 3+4 in the search text box and press enter. You can also do something like 12*(5+5)-12/4

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]