2009 - Page 31 of 12 - SQL Authority with Pinal Dave

SQL SERVER – Order of Hotfix and Service Pack

June 6, 2009

On an average once a week I receive a question from my readers regarding what should be the sequence of hotfix and service pack. Not long ago, one of my regular readers who is using SQL Server 2000 asked me how can he improve the installation speed as he has…

SQLAuthority News – Rambling of Author and Technology Musing – Bing, Google, Windows 7, Books, Blogs, Twitter and Life

June 5, 2009

Pinal Dave

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

DBA, Google, MVP

I have been planning to write a general post on the latest technology for a long time but SQL keeps me so busy that I hardly get time. I know being busy is no excuse as everybody is busy with something. A manager is equally busy managing people as much…

SQL SERVER – What is Interim Table – Simple Definition of Interim Table

June 4, 2009

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Sometimes a simple question like “What is interim table?” can initiate a never-ending discussion between developers. I experienced this recently while I was on phone helping my friends working in Los Angeles. In a conference call, one of the developers kept on talking about “first interim table” and “second interim…

SQL SERVER – Connect Item – Vote for Feature Request Function TRIM

June 3, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Till date, I have met the SQL Server Product Team twice: first time at SQL Server MVP Meet, Seattle, and second time at TechEd India 2009, Hyderabad. At both the times, I have put forth one request to the product team regarding implementing of function Trim(). As per my opinion,…

SQLAuthority News – Summary of TechEd India 2009 – A Grand Event

June 2, 2009

Pinal Dave

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

MVP, TechEd, TechEdIn

TechEd India 2009 was undeniably a magnificent success! The 3-day grand event was adorned by delegates, sponsors, partners, customers, media as well as celebrities from cross the world. The event was marked by the CEO of Microsoft Steve Ballmer‘s keynote, Academy Award Winner Film Sound Designer of Slumdog Millioner Resool…

SQL SERVER – List All Objects Created on All Filegroups in Database

June 1, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL System Table

When I pen down any article I always keep my readers in my mind. With every topic of SQL server I cover, I try to bring readers closer to this technology. So, whenever I receive follow up questions from my readers I am exhilarated! Sometime back I had covered a…

SQL SERVER – Create Multiple Filegroup For Single Database

May 31, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains me from answering all your questions, but I do try my best to entertain them whenever I can. Today’s post revolves around a question I received a number of times last year…