I much prefer your method

good job

maye use CHECKPOINT.

BOL says:

Forces all dirty pages for the current database to be written to disk. Dirty pages are data or log pages modified after entered into the buffer cache,...

Although I seem to have established that the error is not related to the table structure or the actual data, I haven't found a solution yet. Has anyone else come...

unlucky deadline...

I also tried to backup and restore the database to no avail. I found the pasted text in an msdn article:

You cannot shrink an entire database to be smaller...

Hi,

I have recreated your situation and am also unable to shrink my empty datafile. It seems that datafiles can't be shrunk, which would release the partioned data. This is, I...

sorry, hard coded in an application using a connection string

Not sure if this is any help but if the objects are being created from a job then it could be that your developer has changed the "Run as user:"...

1st prob:

- make sure there's enough space in a temporary filegroup before your DBCC SHRINKFILE (increase by 10%, if space is a serious problem, modify the fill factor of your indexes,...

It's generally not a good idea to restrict the tempdb as it needs to be able to grow dynamically

What recovery mode is your tempdb set to?, should be Simple (but...

just had another idea: DBCC FREEPROCCACHE

looking at your original post, it seems that the only thing out of the ordinary is the number of stolen pages.

maybe schedule this to run...

dude, what's running there?

have you checked if you have any recursive cursors that you aren't closing AND deallocating?

have you perhaps set SET CURSOR_CLOSE_ON_COMMIT OFF, remembering that your server properties may have...

The first thing you need to do is consider what you're using raid for? Redundancy or speed are your primary concerns.

- if it's speed (highly transactional) use raid 0 (there is...

the wildcard character implies that there's either a single (_) existing character or multiple (%) existing character where you've inserted the wildcard

instead of searching for table1 like '%1%' search for...

u'r right about the distinctions in the roles, I often find that in smaller environments (up to 100) there's an impression that there's no need for a dedicated dba/developer. What I...

Thanks for you help so far.

The table has six columns and I don't think it's got to do with the data or the table structure. I can't help but deduct that if that...