if you use another server it will impact network traffic. If you write to a table it will impact wherver the table is. If you're logging choose a fast drive...

In general terms the optimiser creates stats on columns that it feels are useful - I often view this as showing poor indexing. You could try dropping the system stats...

you can't allocate processor time. However if you work on producing a poor query without indexes I'm sure sql server will attempt to use 100% cpu

that's an interesting question being as most people are usually asking for the reverse.

Firstly I assume you are running on a multi proc box ? otherwise the answer is no!

The...

no offence intended Jeff but I think you haven't read the original post fully.

do I assume this was a sql 2005 install that failed? If so at what point did the install fail, e.g. which parts did install, what o/s are you installing...

I don't think there is an absolute " right order" it depends upon your window and circumstances. I usually do the integrity checks first, checkdb, check catalog. Then I usually...

it could be the account does not have right permissions. Hung connections tend to need a server service restart to clear.

as far as I could see xp_cmdshell produces a null...

you'd need fn_getsql or dbcc inputbuffer.

Make sure you understand the implications of placing triggers on a table - if your database is transactional you may find you take a...

sorry I didn't explain myself very clearly - what I meant to say is that adding additional files to an existing  filegroup where the database currently has one datafile won't...

I don't usually work with production databases in simple recovery mode to be honest - I'm usually into transactional systems. However I currently do have a few but none refusing...

what you're asking can be done, but not how you're asking - if that makes sense.

You can split data between filegroups by setting secondary filegroups and designating which tables/data/indexes live...

you might like to check this link and patch

http://support.microsoft.com/kb/909369/

just in case the link doesn't work check out the fixes in the post sp4 patch rollup.

The configuration of AWE within SQL Server shouldn't be confused with the o/s making the memory available. Regardless of o/s you still have to enable awe within sql server. with...

I have to admit I've not used calculations etc. in table variables, there are a number of "issues" with table variables which may or may not be a bug .....