Get the cheaper disks and use the money to buy a SCSI attached disk cage with 17 bays. Load it up with smaller disks to give you more spindles.

Would the results to

DBCC SHOWCONTIG ({table_name}) WITH TABLERESULTS

Give me good numbers for this?

I agree with Michael Romm about using backup restore for this. If your restores complete fast enough. This can all be automated in a nightly job using TSQL statements....

My databases are smaller and my biggest backup file is under 3G. I backup some databases directly to a W2K compressed folder. It is SLOWER than backing up to a...

Cast and concatenate the results into a single varchar column and return that

How much memory in your server? What size is your page file and what disk is it on?

I heard a story about a guy who set up his ODBC in his DMZ using TCP and then disabled NETBEUI to protect against Worms. (or was it NetBIOS?) Does...

Work out the TSQL for the backup and put it in a stored procedure that the user can run with little app?

In your DMZ use local accounts with synced names and passwords. For example: servera\IUSR_WEB and serverb\IUSR_WEB with both accounts having the same password. Servera is your web server and is...

I would look at the application that will be used to access your data. Most of our apps add the requirement that the application check for valid values so...

To back up to network file share, you need the SQL Server service and SQL server agent accounts to be a domain accounts with access to the file share. ...

See

Microsoft Knowledge Base Article - 321185

HOW TO: Identify Your SQL Server Service Pack Version and Edition

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

You want the Edition I think

Edited by - robinhc on 08/08/2003 11:37:17...

We recently put in a SQL Server Active-Active Cluster for an application that will have 25 users and up to 10 developers. We bought two (2) "MS SQL Server 2000...

We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we...

I think you can write the SQL in QE and then paste it in Crystal Reports and set it to run as a pass through querry.