Cheers for the posts so far chaps, i think i may have a solution to the partitioing issues. I may be able to get a new server and virtualise it...

GilaMonster, the general performance of the system is fine, we monitor it daily and look to tune the top 10 worst performing procs constantly. The issue we have is as...

SQAPro (2/17/2009)

---

If you have not already tried using it, the SP_WHO2 stored proc can also reveal a lot about what processes have locks or are waiting on locks, and also...

cheers for the scripts guys. I've been doing a bit more digging and thinking it could very well be the issue described here: http://www.red-gate.com/messageboard/viewtopic.php?t=4240&postdays=0&postorder=asc&start=0

The only common theme i can find...

cheers for the suggestions so far chaps.

Steve, we are currently doing as you say but i was just looking for peoples experiences with the full versions, something i may miss...

does anyone know of a way to to back up a partitioned db and restore to a standard version? I would really like to implement this strategy but can't justify...

thanks for the reply. If that is the case then why is there the "Sparse" column feature in 2008? If NULL takes up not space at all then surely there...

what about checking the error logs?

Thanks to all that replied to this thread, your thoughts / ideas are gretly appreciated. I'm gonna go for the 2 table and one job running every min route, simple...

anyone??

There must be a better solution than creating a snapshot every day/week......?

i think i may have an answer for why it is happening. Every evening we perform a delete of certain tables from that publication (on the replicated server) to keep...

out of curiosity, from a performance point of view, which is better:

setting WITH(NoLock) on every table or setting the isolation level (if different from Read Uncommited) at the start of...

have you got auto update / create stats enabled?

can you explain the rare situation you are referring to?

We have our auto stats turned...

glad u got it sorted!