Thanks Jeffrey.

With your SSIS project approach, are you able to get the package to log to the existing maintenance plan tables in MSDB? And have Management Studio recognize your package...

Thanks Jeffrey,

Sounds like you are a proponent of #3, mentioned in my original post. If I do stick with a Maint Plan-based strategy, then #3 seems the most feasible to...

GSquared,

Thanks for your post. Yeah, I'm seriously considering the Proc/Job approach instead of a Maint-Plan-based approach. The only reason we haven't done that yet is our frontline support (the analysts...

You know, I've always wondered about the Lock Isolation level for the Stats Update process... I guess I'd always assumed that the DB engine just used dirty reads b/c the...

No, I never did. We ended up solving the problem we were troubleshooting and I never spent much more time trying to figure out the 1222's on SPID 21.

If you don't mind doing a bit of reading, Erland Sommerskog has one of the better write-ups on SQL Server error handling:

http://www.sommarskog.se/error-handling-I.html

About a third of the way down...

When I've had performance issues with large, batch-like tasks, I've usually disabled the trigger temporarily (i.e. right before the INSERT(s) ) and then re-enabled.

Is there concurrent activity against this table...

Emily,

My recommendation would be to encapsulate each Update in a BEGIN TRY...END TRY / BEGIN CATCH...END CATCH block.

If you are on a pre-SQL 2005 install, this won't be available...

I've wondered in the past why MS (or for that matter, Oracle or IBM) hadn't developed a specific "database appliance"--hardware with software specifically built to run just the database software....

For OLTP: make sure you take into account the size of a row in the table (if the row has Varchar columns, probably use the Avg actual size) when choosing....

what if you had multiple application databases that needed to be failed over at the same time? i.e. interdependencies? In that case the inflexibility of clustering would be a good...

Hm...I don't think we'd have any SELECT INTOs that would run for 24 minutes, or enough of them to consume that whole range of time. We use that syntax mostly...

sturner,

Thanks for responding.

We could be running SELECT INTO at/around that time. At that time of day we have some import processing running. Unfortunately, my trace window started after the imports...

Sander,

I'm curious...Were there any suspicious-looking error messages in your installation logs?

Also, what did the Windows Event logs hold (both Application and System) for the failed service start that corresponds to...

John,

Could you clarify something?

I understand how .NET CLR and Linked Server queries (and extended stored procs) make use of the Virtual Address Space in the Database Engine's process. However, you...