No always ... with no index on the column a 'table scan' would be used. With an index on the column, worst case, an 'index scan' is performed. Still not...

All the software in the world will not help (no matter how good it is or it's review or cost) unless there is 'management'. Primarily I mean project management (your...

I also believe that the optimizer works better with "=VALUE" as opposed to "!=VALUE" or "<>VALUE" if the column is indexed.

The only issues that I am aware of are covered in the following link:

http://www.microsoft.com/downloads/details.aspx?familyid=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en

I am also assuming that you are installing SP3 in an automated fashion as well.

A DBA is only as good as his last restore ...

I've had this problem in the past a few times. Depending on the privileges of the logins (whether you use integrated security or SQL security does not really matter), you may have...

Just a questions:

Are there any objects that begin with '1' in the database ?

If so, then it needs to be renamed or escaped ... e.g. N'1 table'

dc, you are correct since they are using local disk. In my environment this is not an issue since all databases (data/log/backup) are on separate SAN Meta-LUNs. So the worries...

Here's a 'must have' for every DBA's desktop ... it's an electronic version of the systemtables in databases ...

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

There is one advantage to using 3 separate databases (one table in each) vs. 3 tables in one database that has been overlooked. This is the distribution of transaction log activity....

Here's a few questions for your SAN admin to start with ...

1) What RAID Level are you using (1,5 or 1+0) ?

>>> The different RAID levels determine optimim read or write...

Presently I am not certified ('certifiable' possibly). I've worked with SQL Server since v4.2 on NT v3.5. My thoughts on certification are, well it's just not cost effective nor...

Your SAN administrator should have software provided by the vendor(s) available for performance monitoring. e.g. EMC, Hitachi and maybe Veritas if you are utilizing the disk management software. The catch...

Here's the scenario:

SQL Cluster HP-DL580/HP-DL380 - active/passive

4 - 3.0 Gh Xeon CPUs

4 Gb RAM --> 3 Gb dedicated to SQL Server

EMC SAN storage --> db data/db logs on separate meta-LUNs

Database size...

Are there any indexes present ?