Im designing a system to scale to 12,000 TPS. It involved some clever tricks such as using Service Broker for Lazy processing.

sean you were referring to the default transaction mechanism unless im mistaken. And if thats what your saying id be very curious to hear how you think that works internally....

Sql server has a number of background processes that it uses to manage internal activities, like ghost cleanup, resource monitor etc. I cant remember the name of the process that...

what i mean is the mechanism that you are talking is handled by a background sql process. In sql many of these processes run asynchronously and not continuously

Having tested it on a very large table. The transaction rolls back. Although i know there is sql process that kicks in periodically to rollback transactions. However not sure if...

sorry the update does the select implicitly and outputs the data using the output clause. The other way to do this would be to break it down, something like

create procedure...

Many thanks Duncan, I seem to have got it working following your steps.

Using cnames instead of A records was probably a big part of the problem.

Im trying to load balance SSRS and I thought this was a prerequisite. Also I was under the impression that if I wanted to use integrated security for the SSRS...

Thanks Abhijit, NTLM only connects remotley for FQDN. DNSAlias and FQ DNS Alias. I will still need to configure for keberos though.

I forgot to add, Kerberos is working fine for single and double hop with Sql Server which is on the same box as SSRS

Thanks for the response, I would like to try but it uses a separate NIC for the purposes of network routing. This mirror setup is over WAN so its important...

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64>...

Great script. The modified version works great (maybe you should update the original article)

Only problem is I get the error:

Msg 9436, Level 16, State 1, Line 7

XML parsing: line 3,...

First class article, do you have any benchmarks about how it improved performance?

looks like you are using global temporary tables which may cause blocking:

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html