All Articles - SQL Authority with Pinal Dave

SQL SERVER – What is Your Favorite Database? – Poll Continuous

March 12, 2009

I have published SQL Server Poll about What is Your Favorite Database? to get feedback from readers of this blog about what is their favorite database. I have received so far tremendous response. This poll will continue through out this month and will close on 1st of April. I will…

SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison

March 11, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

More than a year ago I had written article SQL SERVER – Union vs. Union All – Which is better for performance? I have got many request to update this article. It is not fair to update already written article so I am rewriting it again with additional information. UNION…

SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 10, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

Today we will look something which is very quick and but quite frequently useful string operation over numeric datatype. This article is written based on a question asked by one of the users (name not disclosed as per request). Let us see how to show a fixed width number display.

SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip

March 9, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP, MVP Summit 2009

Today I have arrived in India and back to Ahmedabad. I have left my home on 27th February and arrived back at my home on 9th March. I was traveling for total of 10 days out of 2 days were just technically included as they were very little occupied. I…

SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009

March 8, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, MVP Summit 2009, SQLAuthority Author Visit

I am currently at Mumbai Airport and waiting for my flight to Ahmedabad. I am little exhausted but had great time at Global MVP Summit 2009. There were lots of South Asian MVPs present at global event as well. We all had great time to network with each other and…

SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions

March 7, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQL User Group, SQLAuthority Author Visit

I can talk about database almost all the day. Yesterday I had two technical meetings. One with Tech User Group of Markham and another with TorontoCASolutions. Let us go over my summary of both the meetings. Tech User Group of Markham, Canada Steve Jagadishan is very enthusiastic leader of the…

SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database

March 6, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, MVP Summit 2009, SQLAuthority Author Visit

I am traveling to Toronto from Microsoft MVP Sumeet. I will be very tired as I am continuously working very hard from last 27th Feb. I am still Jet Legged from my trip from India to USA and now I am again changing time zones by visiting Canada. I get…

SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer

March 5, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, MVP Summit 2009, SQLAuthority Author Visit

An action pack day with lots of tech session and 4 back to back Keynote sessions is over. Steve Ballmer presented one of the keynote where all attendees really felt energetic. Steve is the person who has so much energy that may be 16 year old kid feel older in…

SQLAuthority News – MVP Summit 2009 – Day 3 – Party Day and SQL Celebrity Photos

March 4, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, MVP Summit 2009, SQLAuthority Author Visit

Today was the third day of MVP Summit 2009 and it was wonderful. I had my dream come true as I was able to meet Kalen Delaney – a legendary author of SQL Server and truly living SQL God. If I had not met her today, my trip to USA…

SQLAuthority News – MVP Summit 2009 – Day 2 – Most Contributing MVP of Year

March 3, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, MVP Summit 2009, SQLAuthority Author Visit

Day 2 of MVP Summit 2009 was filled with Back to Back Technical session. However, due to NDA I will be not able to share the details about the session. I even verified that I can not even post the title of the session which I have attended. I can…