Thanks for the reply. I cannot get the archival query to execute at this time because it can never get a memory grant from SQL Server, so I cannot check...

1. The server is Enterprise Edition. I would love to give the server more RAM, but people other than the DBA's dictate how much RAM the servers get and we...

A reboot overnight seems to have cured the problem.

Chris

Have you tried installing SQL 2005 on your box? I have 2005, 2008, and 2012 version of SQL Server and BIDS installed on mine. I know I installed 2005 after...

If you have to limit TempDB due to space constraints, you gotta do what you gotta do. This will result in failures on the app side if it cannot use...

OK, here are three. I had to change the extension to upload them. SSC does not allow XDL files.

Thanks,

Chris

I am not familiar with what a deadlock graph looks like, so I'm kind of in the dark here. I looked at that article and what is described as a...

Here are three images. Is this what you need?

Jeff,

I am reviewing your suggestions and trying to implement them today.

Thanks,

Chris

Jeff,

In a perfect world this never would have happened. In my world, ruled by management, I can only be as heavy-handed as they will allow me. My first suggestion was...

And if you do determine that a procedure is probably not used, you would be wise to rename that procedure for a period of time rather than delete it. This...

Yes, your post did say that. In my case though, I found the other yesterday and didn't get back to this post until this morning. Either way, thanks.

If you would...

ScottPletcher, yes, AuditLogID is the clustered Index and an Identity column. I am always interested in better, faster ways to make things happen, if I can maintain data integrity.

I have...

Where I need the better performance is in my archival process. I have to work around the inserts from Biztalk, to log to three different tables, at a rate of...

After meeting with some of the principals we are looking at improving the query and view designs. I generated an execution plan for the query/view and found the largest, ugliest...

Gee, and you guys haven't even seen the underlying view this query is acting on. :w00t: I don't ever think I have seen a more complicated execution plan than what's...