You are correct Steve (it's one of those 'automatic' things) ... Here's the link:

http://support.microsoft.com/default.aspx?kbid=246133

Why build on David's suggestion not devote 2 columns instead of 1. The first column is a creation date/tim, the second column is a modification date/time. (it's something we did...

It just goes to show you that "Locks only keep honest people out" ...

v7.0 database to SQL2000 ??? Well in order to do that you have to perform backup v7.0 copy the file(s) and restore them on SQL2000. Things should be converted during...

... or 2^31 ...

... however anything nearing that capacity I'd like to hear about --> just so I can know where it is and never have to see it !

Since "We do not have backups for this database!" I believe that your only course is to call MS PSS and hope that they have a solution.

Give this a try:

kill the spid for the script (if it is still active)

exec sp_resetstatus @DBName='your_loading_database'

drop database your_loading_database

Try using your PK instead of * in the count function. It should reduce the time needed for execution by a great amount. If the table has multiple indexes then...

Is this the beginning of the media hype to create the hysteria over the coming calamity over the addition of 1 second ??? Well if it is, it's only a...

Here's a script provided by MS PSS as a work around:

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER ON

SET NUMERIC_ROUNDABORT OFF

GO

EXEC SP_MSForEachTable "DBCC DBREINDEX ('?')"

GO

Your existing table is 334 GB. Using the 'times 2' rule you are going to need 668 GB of database space to rebuild the index and at least that much...

Your point about the differential backup is a very good one as well SQLBill. As for "a lot of restores", yeah in my case yes (every 15 minutes). But using...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

Round II

    DBCC DBREINDEX

    UPDATE STATISTICS (with FULL scan)...

The only point I would add is that at a minimum you need nothing less than dual CPUs <period> Xeon processors are even better.

The answer is no if the database recovery mode is still set to it's default of 'simple'. If you changed the recovery mode of the database to 'full' and implemented...