Sorry, but this is a HORRIBLE recommendation!! Please read the referenced...

I agree with Gail - LOTS of potential culprits here (statistics, locking, IO issues, virtual machine stuff if on VM, bad plan in cache, other stuff running on server either...

I can probably count on my fingers and toes how many times (in 15+ years of consulting on SQL Server) how many times an index on a temporary table provided...

rudy komacsar - Doctor "X" (4/11/2012)

---

Some 'practical' experience in this particular subject says:

- no more than 8 files

definitely no more than 1 file per socket as...

try out DBCC memorystatus. It is documented online by Microsoft but not in Books Online.

It could also be that the history table isn't defined EXACTLY like the base table.

Since you mention you want to document SSRS, SSIS, as well as SQL Server I would recommend http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx. If you didn't need that non-engine stuff I would recommend Embarcadero's...

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDAQFjAB&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F4%2F7%2Fa%2F47a548b9-249e-484c-abd7-29f31282b04d%2FPerformance_Tuning_Waits_Queues.doc&ei=HwZ_T5mVG5Ki8gT09Z3UBw&usg=AFQjCNFRIebSlMLnry8gH99CQklhdmokJw

and search web for track_waitstats_2005

I was afraid of this: that set of stuff is well beyond what I consider appropriate for a forum assist. I don't have enough free time to dig...

Search the web for Brent Ozar blitz (or sql server take over) and also for Glenn Berry diagnostic. They both have great stuff.

ADO Classic looping code like you have is killing you on the round-trip time. I don't need to see your queries to tell you you need to refactor them...

Hey guys - PLEASE don't post to a 3 year old thread!!

Here is a good resource for a novice looking to resolve deadlocking issues:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

I warn you that it can get...

bpw (3/29/2012)

---

Thanks again Gail. I've read your post and watched a video you linked to - very useful.

I'm a bit confused about stats now, as DTA recommended creating lots (19...

>> table data increasing heavily

This makes me feel that manual statistics updates could also be a big benefit. With a large table you need to insert/modify 20% of the...