purpose of life is joy


How to : Use conditional WHERE clause using CASE statement in MS SQL Query

Adding case statement in where clause sometime we may not get the exact output we required. some solution suggested to add or condition instead of using case statement which again not giving desired results. but one solution I have found using case statement in where clause in reverse way. [More]

How to : fix SQL timeout error from ASP.NET (Parameter Sniffing)?

Recently, I have faced an issue while developing an application using MS SQL 2008 and ASP.NET. I have created a SP which is running fine in from SQL Server Management Studio. But, When I execute it thru the asp.net application, it is timing out. i tried debugging and doing R&D. but in vein. later on i found the reason in the web saying parameter sniffing. Parameter sniffing? Oh yes. this is new to me. what is this by the way? [More]

How to : bold an item in a dropdown using CSS in HTML?

I was trying to find a solution to bold an item in drop-down. I tried using <b> markup from the code itself. but nothing working. finally, after come across with the some webpages, i found this solution. but this will work only with the Firefox not IE :( [More]
Protected by Copyscape Web Plagiarism Check