This is also true of particular types of "systems". For Example, if payroll operates as expected, nobody pats you on the back. BUT if there is an error...

The renewals are not as "automatic" as they have been. I believe they are looking for new blood and evaluate the performance evenly. If an MVP is not...

I can think of several folks who I believe should be MVPs, but they aren't for whatever reason. The selection process is not perfect, but it is not MVPs...

Oracle RAC - How many companies are currently running it? If they are, how many nodes? I am not an Oracle afficiando, but I have heard from some...

Great responses. Also, planning is KEY! I have a script that illustrates some of the partitioning limitations in 2005 at http://www.ricksql.com. I use it in...

Hmmm... Nobody here suggested getting certified. I will leave that for another debate, but if you ask DBAs how they became one, they will respond that they...

Also, Partitioning takes a lot of planning. If you want to maintain partition alignment so that you can "Switch" partitions in/out, the indexes will need to be partitoined in...

Unfortunately, there is not a databse level timezone setting. I have come across this issue before with one or two clients. As we consolidate many servers recently, it...

Your Partition Function  must map the entire domain of values.  If it is a two character field, you can setup boundaries to separate the partitions.  You will need to add...

The weirdest question that I had was "What one word makes you stop and think?".  Since there was Trekkie stuff in the office, I said "Spock!".  I was hired.  Months...

I second the opinion that you should test it on the test server first.  BTW, there is a tool called Upgrade Assistant (not Upgrade Advisor) that allows you to compare...

Great Topic -Answer of course is "It Depends".

But, for general best practices, check out http://www.itsshowtime.com for a webcast fro Kimberly Tripp on Best Practices for Indexes.

There are so many...

At the PASS SUmmit, Attendees were asked if they had at least ONE server in production that was on SQL Server 2005.  About 70-80% of the attendees indicated YES.  When...

Oracle and DB2 charge EXTRA on top of the Enterprise License for the partitioning feature.  Part of the reason that it is in Enterprise Edition is that this feature is...

MSFT will make an effort to supprt SQL Server on VMWare, but they will eventually ask you to move to "bare metal" if no progress is being made on the...