We have been using it for about a year now and it is very impressive.  Since IMCEDA brought the company dbassociates, earlier this year the price of the product has...

Thanks Guys for your response.  The people setting up the Doc loading server had turned on odbc logging to diagnose another problem.  The log file had grown to 17 gig...

Are you using standby files?  Because SQL server will get to the end of the transaction log restore, find there is no commit and then write the whole uncommitted transaction...

Are you physically on the Local machine using query analyser?, or are you using query analyser from your workstation to the local machine?

If you are connected via your workstation, you...

I would be very surprised if SQL is the bottle neck.  We have an EMC SAN connected to a 4way 2gig processor machine with 8 gig of ram, win2k, 2x2gigabit fibre...

I think everyone is on the right track with the RAID levels to use for data, log and tempdb, but for the best performance you need to look at what...

SQL Server will predominantly use what ever is the cheapest in terms of I/O.

Running 'SELECT emp_id FROM Employee' uses the non clustered index at a cost of 1 i/o.

Forcing it...

In addition to the last post, you can also use ctrl + shft + T   (Trace), this gives you a quick indication of which parts of the sp's are taking...

There are no system stored procedures in a newly created database. Only system tables and views.

If you want to run system stored procedures (master or msdb) from your database...

If you have 72gig drives then you would split each drive into 18 x 4gig volumes (meta's) or even 2 gig volumes and then stitch them back together with 4gig volumes...

Power path is an EMC product, compaq probably has there own version of it.  It effectively balances the traffic across all the fibre channel paths to the SAN

The disks in...

Check your HBA's are configured for max speed, probably 2 gig.

Use Load Balancing software like power path to distribute the traffic over the HBA's.

Use as small as possible meta's when...

For the message above Make the Union a UNION ALL and the duplicate records will be removed.

Create a batch file with these commands in it.

Type c:\Test\*.sql> c:\Test\ExecuteAllFiles.sql

Save it as c:\Test\ExecuteAllFiles.bat

Execute the batch file like this

master..xp_cmdshell 'c:\Test\ExecuteAllFiles.bat'

Run the output file.

master..xp_cmdshell 'osql -E -d Test -i c:\Test\ExecuteAllFiles.sql'

Essentially the batch...

use northwind

go

sp_msforeachtable 'sp_spaceused ''?'''