Here's another arguement for the Production DBA (at least in an enterprise environment) - To act as a bridge between the Development group(s) and the System(s) groups. My past has...

I can just guess the answer - 'In that case, you'll need 6 eight-way servers, and you'll even have room for an additional user!'

He was only the software vendor, we were a Compaq (HP) shop, and did all of our own purchasing. We bought the software, but did not take his sizing recommendations...

Like Remi said, there are way too many variables (CPU, memory, usage, server load, disk subsystems, etc.) to say something like 5 to 6 is the max.

When dealing with...

No question of the length of today's question of the day can convey enough information to completely define a current backup solution, much less a current and proposed backup solution....

i don't know if this is what you are looking for, but you can always query the information_schema views (information_schema.tables, information_schema.columns, etc.).

A little more info... The key names aren't specified in any of the scripts generated. The interesting thing is that if you go into manage indexes, then double click on...

Right click on the ProcessID (spidxxx) in the tree view, then select help. It explains owner in there (it is the lock owner, not the object owner):

You shouldn't have to create a new database. You can Right Click on Databases, then choose All Tasks => Restore Database. You can enter whatever name you want to in...

For more of a step by step guide, check out 'copying databases, overview' (search) in Books Online. It gives a good overview, with examples in T-SQL and Enterprise Manager.

Also, when you are restoring on server SQL2, make sure that you check the paths listed in the Restore As area on the Options tab. If these drives and aths...

Look up CASE in Books Online. Sounds like exactly what you are looking for. Ex.

USE pubs

GO

SELECT    'Price Category' =

      CASE

         WHEN price IS NULL THEN 'Not yet priced'

        ...

Getting scuba certified and getting my MBA are in my future (long term), as well as a pint or two later tonight at the local Irish pub (ongoing)!

Log shipping is good for a warm stand by, but it doesn't really come close to clustering (and it has some problems of its own). The two technologies that I have...

Yep, I can get the basics done, but every once in a while I coma across someone doing something in T-SQL around here that I'd never even thought of trying....