Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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
Mangal P. posted an article on
Mangal Blog
-
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 P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Mangal P. posted an article on
SQL With Mangal
-
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
Recent Discussions
