SQL Archives - Page 399 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias

June 7, 2009

Strange it may sound but being a SQL Server pro has its downside too. Common information on SQL does not interest me, while a good document is hard to find. So the reader in me is mostly discontented and constantly keeps looking for interesting documents. Recently, I chanced upon a…

SQL SERVER – Order of Hotfix and Service Pack

June 6, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Service Pack

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…