I think I've looked at the code for too long and can't see the obvious, can you please tell me where I am missing that?

Anyone?

Can you post the DDL for your tables...Also, is there any particular reason you have a seperate table for each year? Why not have all the data in one...

Sounds like you're using the Idera SQL diagnostic manager 😉

Have you been able to view the Deadlock graph? I believe it's "Show Deadlock View" - you have two different...

Not sure if anyone else experienced this issue, however, I'd like to share my experience:

I modified the code a fair amount but kept the "core" portion of it in tact...

Can you please post/attach your query execution plan?

It is my understanding (others than correct my ignorance if needed) that an indexed view is just that, it's "indexed", the entire view...

I've not actually used it before, but have read some articles on using the Resource Governor - could you not try using that to restrict memory usage/cpu/etc by application?

Laymens terms (from the articles listed above):

sp_executesql has the same behavior as EXECUTE with regard to batches, the scope of names, and database context. The Transact-SQL statement or batch in...

Check your inbox, I've sent you the code needed and the basic instructions on how to set it up (shouldn't take more than a few minutes) - Good luck!

I'll send you something tomorrow that might be useful...currently OOO

Aren't they removing named pipes entirely from the next version of MSSQL?

Create an RDL file (Reporting Services Report), set up multiple datasources (to the servers you want this to run on), then you can use the following query to get basic...

Yikes it's one of those days :w00t: I'm going to have a glass of water to wash down my foot!

How busy is the server during the time of failure? If there's a lot of connections, I/O or CPU utilization going on, I've seen (many times) that specific driver...

I stand corrected 😀

Lowell, I love your example however, there's one small error in your code, it errors out at the SELECT:---Can clarkKent see the table he...