Mangal P.

14 Followers
15 Blog Followers
1 Blog Reviews
Following: 5
Following Blogs: 1

Latest Activity

ORDER BY Enhancements in SQL Server Denali

Mangal P. posted an article on - Nov 13, 2010, 1:44 pm
Today I am going to talk about one new feature that is been introduced in the SQL Server Denali.   And that is:  one interesting enhancement in ORDER BY clause.  Now with ORDER BY clause you can also specify the OFFSET and FETCH options.  From Books Online of Denali: OFFSET: Specifies ...
Comment - Like

Some Things About VIEWS

Mangal P. posted an article on - Aug 31, 2010, 11:47 pm
Everybody has different views about VIEWS, that’s what make them interesting topic to discuss.  Other thing is if you make some assumptions about VIEWS, they can lead you to problems.  As my target audience is SQL beginners, today I’ll talk about few things about VIEWS so some of the obvious m...
Comment - Like

Convert Seconds to HH:MM:SS

Mangal P. posted an article on - Aug 24, 2010, 1:35 pm
Today 2 of my colleagues from reporting team had this requirement. They had one table where Seconds were stored as INT and in report they wanted to convert the seconds to HH:MM:SS format.  They already had 1 solution ready with them.   It was something like: -------------------------------...
Comment - Like

SQL Myth: Primary Key and Clustered Index

Mangal P. posted an article on - Aug 20, 2010, 2:24 pm
After remaining quiet for almost a year I’m back with what I enjoy the most, talking about SQL and sharing whatever little knowledge I have.   Many SQL Developers have this misconception:  “Primary key => Clustered Index: Only a Clustered Index can exist on a Primary key column”.     On...
Comment - Like

Where is God?

Mangal P. posted an article on - Jul 6, 2009, 6: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 probably involved. The boys' mother heard that a preacher in town had been successful in disciplinin...
Comment - Like

August 7, 2009,at 12hr 34 minutes and 56 seconds

Mangal P. posted an article on - Jul 3, 2009, 1: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 happen in your life again!!!!
Comment - Like

Ladies please hear this!

Mangal P. posted an article on - Jun 4, 2009, 5:17 am
At last a guy has taken the time to write this all down! Finally, the guys’ side of the story ( I must admit, it’s pretty good) We always hear ‘ the rules ‘ from the female side. Now here are the rules from the male side: These are our rules! Please note.. these are all numbered ‘1 ‘ ...
Comment - Like

The Sweet Coffee!!

Mangal P. posted an article on - Apr 29, 2009, 2:40 pm
An amazing Love Story. He met her on a party. She was so outstanding, many guys chasing after her, while he so normal, nobody paid attention to him. At the end of the party, he invited her to have coffee with him, she was surprised, but due to being polite, she promised. Th...
Comment - Like

The Superstitious President!!

Mangal P. posted an article on - Apr 25, 2009, 4:27 am
  Here is my Puzzle Of the day.  I already posted 3 puzzles, you can find them under the Puzzles category on blog.  For answers or any queries you can contact me on my mail mangal.pardeshi@indiamvps.net. Puzzle - Mr. Fisher is a night watchman in a large company. On a certain morning whe...
Comment - Like

New 10 Rupee coin

Mangal P. posted an article on - Apr 22, 2009, 8:43 am
  The Reserve Bank of India will shortly put new coins of Rs.10/- into circulation. This design has been prepared by National Institute of Design, Ahmadabad with the theme of Unity in Diversity. The outer side metal is Nickel-Bronze and the inner side metal is Ferrous Steel. The weight o...
Comment - Like

Too Cool!!

Mangal P. posted an article on - Apr 22, 2009, 8:16 am
One morning at a doctors surgery a patient arrives complaining of serious back-pain. The doctor examines him and asks him" OK, what happened to your back?" The patient replies "You know that I work for a local night club? This morning I got home to my apartment early and heard a n...
Comment - Like

ENJOY EVERY MOMENT OF LIFE

Mangal P. posted an article on - Apr 20, 2009, 3:50 am
You Can’t Recover...                                                          The Stone...                                                                       ...
Comment - Like

What is the color of person A's cap?

Mangal P. posted an article on - Apr 16, 2009, 3:51 am
Puzzle Of the day. I already posted 2 puzzles on my blog.  You can find them here – Puzzles.  Here is another puzzle on the list from my side.  For answers you can contact me on mangal.pardeshi@indiamvps.net . In a small village in the middle of nowhere, a dacoit caught three persons A, ...
Comment - Like

Mangal

Mangal P. posted an article on - Apr 14, 2009, 12:33 pm

Comment - Like

UNION Vs UNION ALL

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 UNION.  Then again question arises - Why UNION ALL performs faster?  Also - Why whenever possible, ...
Comment - Like

Microsoft SQL Server 2008 R2 CTP

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 related links See - http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx If you have any questions reg...
Comment - Like

ROLLUP and ORDER BY

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 ROLLUP/CUBE queries. The reason I’m writing this post is, sometime back I seen somebody writi...
Comment - Like

TSQL Challenges

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 to be a part of a team consists of people like Jacob, Alejandro Messa, Peter Larsson (all 3 are SQL ...
Comment - Like

Multiplying Column Values

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
Well we all know how to add the values in a column using SUM and GROUP BY.  But what about multiplying the column values?  And also how to calculate running multiplication on a column similar to Running Totals? Sometime back I came across this interesting question on MSDN SQL Server forums - How...
Comment - Like

SQL Server 2008 Service Pack (SP) 1 on Microsoft Update as a Required Automatic Update

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 Service Pack (SP) 1 on Microsoft Update as a Required Automatic Update For better understanding of ...
Comment - Like

TCP Port of SQL Server

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 trying to access through the default port number.  But that is whole together a different story. Every now and then somebody posts this question on forum...
Comment - Like

PIVOT Multiple Columns

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 columns?”, so this post was due for some time.  Actually I was looking for some efficient way of doing it.  Limitation of PIVOT operator is, it supports ...
Comment - Like

DELETE Vs TRUNCATE

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
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 the blogs, forum threads I keep seeing statements like “TRUNCATE cannot be rolled back”. This is a...
Comment - Like

Alternating Row Background Color in Reports

Mangal P. posted an article on - Dec 31, 1969, 7:00 pm
Now lets see how to get alternating row background colors in Reports. This is one of the 1st typical report enhancement you might be doing once you started working on Reporting Services.  See the following report :  This can be achieved very easily in SSRS with the help of IIF and RowNumb...
Comment - Like

Mangal P.'s Blogs:

Mangal P.'s Followers

Mangal P. is Following

Invite Your Friends

Invite your contacts to blogged from:
gmail yahoo