SQL Tips and Tricks Archives - Page 423 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Lots of SQL Server News – Tip of the Article

March 14, 2009

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

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…

SQL SERVER – Profiler – Adding Filters – Observation on CPU Load

March 13, 2009

Pinal Dave

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

SQL Profiler, SQL Utility

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”…

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

March 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Poll

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…