Viewing 15 posts - 1 through 15 (of 19 total)
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...
November 22, 2011 at 12:56 pm
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...
November 21, 2011 at 10:00 am
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...
November 21, 2011 at 9:58 am
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...
February 2, 2011 at 9:15 am
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.
February 1, 2011 at 5:34 pm
If you don't mind doing a bit of reading, Erland Sommerskog has one of the better write-ups on SQL Server error handling:
About a third of the way down...
October 9, 2009 at 11:16 am
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...
October 9, 2009 at 10:27 am
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...
October 9, 2009 at 10:22 am
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....
August 26, 2009 at 12:12 pm
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....
August 21, 2009 at 9:43 am
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...
August 20, 2009 at 9:43 am
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...
August 4, 2009 at 2:53 pm
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...
August 4, 2009 at 2:31 pm
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...
July 14, 2009 at 9:41 am
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...
July 6, 2009 at 10:42 am