Mangal P. posted an article on SQL With Mangal - Aug 12, 2009, 8:06 am
The first community technology preview (CTP) of Microsoft SQL Server 2008 R2 available for download for MSDN and TechNet subscribers. For more details about SQL Server 2008 R2 and for other relate...
Comment - Like

Mangal P. posted an article on SQL With Mangal - Aug 11, 2009, 2:21 am
In one of my previous posts, I discussed on how useful GROUPING function is while writing a ROLLUP/CUBE query.  One more way GROUPING function can help you is – in ordering the results returned by ...
Comment - Like

Mangal P. posted an article on SQL With Mangal - Aug 7, 2009, 11:57 am
I just like to thank Jacob Sebastian who is a fellow SQL Server MVP and founder of the www.tsqlchallenges.com for offering me an opportunity to be part of the TSQL Challenges team. I’m really happy ...
Comment - Like

Mangal P. posted an article on SQL With Mangal - Aug 4, 2009, 5:10 am
SQL Server 2008 Service Pack 1 will soon be available through Automatic Update starting from September.  For the latest information you can read it from SQL Server Setup blog - SQL Server 2008 Se...
Comment - Like

Mangal P. posted an article on SQL With Mangal - Jul 22, 2009, 3:20 am
Many times you may have heard this “Use UNION ALL over UNION whenever possible.”  The question arises - why?  To answer this question in one statement  - UNION ALL performs faster compare to UN...
Comment - Like

Mangal P. posted an article on Mangal Blog - Jul 6, 2009, 5:46 am
Two little boys, aged 8 and 10, are excessively mischievous. They are always getting into trouble and their parents know all about it. If any mischief occurs in their town, the two boys are probab...
Comment - Like

Mangal P. posted an article on SQL With Mangal - Jul 3, 2009, 12:51 am
I know this has been done many times, but still here is something from my side. What is the difference between TRUNCATE and DELETE? Well one reason I wanted to write this post was, on so many of th...
Comment - Like

Mangal P. posted an article on Mangal Blog - Jul 3, 2009, 12:01 am
So what’s so special about this date and time? On August 7, 2009,at 12hr 34 minutes and 56 seconds , the time and date will be : 12:34:56  07/08/09 1 2 3 4 5 6 7 8 9 This will never ...
Comment - Like