Error 112 always means not enough disk space at that point in time. Do you have other disk ops on that disk at that time - make sure the recycle...

embedded sql is far easier target for hackers and it has been reported that hackers are targetting applications far more now than o/s as it is easier.

Embedded sql is not...

I agree the queries are not the same .. I'd suggest you use showplan etc. to see what indexes etc. are being used and the estmated result set.

The question...

I don't really understand what you are asking. Disk information is available via disk manager in the o/s. You can only add disk space if you have available free disks....

yup!

You really need a clustered index on the table otherwise you have a HEAP which over time will have "holes" where data is removed or updated with deferred updates. Rebuilding...

It's an interesting issue and I probably have some extreme views on HT < grin >

I run a 8 way cluster ( 16 with HT ) on w2003 , also...

do you need ansi nulls off ?

I usually make use of the showplan in QA to improve performance.

As with anything large and complex usually breaking down into smaller parts may...

Disk queue counters are useful and yes nfts fragmentation will not help , but I make use of i/o completion time with idle time to get a better picture. Especially...

If I have the window I rebuild indexes every night. I always update stats every night regardless ( even with auto update stats enabled ).

I had a similar issue - i'll describe - if same follow instrauctions < grin >

stored proc ran badly, if I cut and pasted the code in QA and ran...

Depending how you created the second file it may need objects allocated to it. So if you created a secondary filegroup for your file unless you assign objects to that...

hmmm .. my recollection is that a text column will always allocate 1 page per populated row for the text data regardless of whether you put any data into it....

hmmm .. you might need to stop and restart the sql service, that will create a new error log. I have jobs on my servers which cycle the log every...

With respect you are all missing the most obvious that despite the number of cpu's a query will always only use one thread unless the query/batch is complex enough to...