Pinal Dave - SQL Server Performance Tuning Expert

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

June 5, 2009

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

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…

SQL SERVER – Difference Between Candidate Keys and Primary Key

May 30, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Function, SQL Scripts

Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as…