SQL Master

Many times you may have heard this “Use UNION ALL over UNION whenever possible.”  The question arises - why?  To answer this question in one...

I know this has been done many times, but still here is something from my side. What is the difference between DELETE and TRUNCATE? Wel...

In one of my previous post I showed you how to UNPIVOT multiple columns .  On similar lines I also wanted to write on “How to PIVOT multiple...

By default the default TCP Port for SQL Server is 1433.  It can be changed for security purpose to minimize the potential threat of a hacker...

Now lets see how to get alternating row background colors in Reports. This is one of the 1 st typical report enhancement you might be doing...