SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN
Today I received email from Yoel from Israel. He is one smart man always bringing up interesting questions. Let us see his latest email first. Hi Pinal, I am subscribed to your blog and enjoy reading it. I have a question which has been bothering me for some time now.…
Read MoreSQLAuthority News – Lots of SQL Server News – Tip of the Article
I have been reeving lots of feedback from blog readers and what I have learned that they all wanted me to write about SQL Server Community news at least once a week. I am not sure if I can write every week what are happening in SQL Server world but…
Read MoreSQL SERVER – Profiler – Adding Filters – Observation on CPU Load
Today I am blog about something which I found recently while working with SQL Server Profiler. Profiler can be invoked just typing profiler in command prompt. I am using Windows Vista Ultimate 32 bit (License Version) and SQL Server 2008 Development (License Version). The reason I have put “License Version”…
Read MoreSQL SERVER – What is Your Favorite Database? – Poll Continuous
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…
Read MoreSQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison
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…
Read MoreSQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display
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
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…
Read MoreSQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009
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…
Read MoreSQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions
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…
Read More


