How does the client grab a lock? If your application is built to hold locks on tables, even for seconds, you are killing concurrency.

If there was a warning or non-critical error, things might work.

SQL Server is rock solid on this stuff. I never worry about this losing data from the server. Now my...

There are timeouts for clients, and when a client has a query running, there is some communication back to the client. I'm not sure that the timeouts are, but if...

shikhar_0511 (8/25/2012)

---

Actually the data consist of tonnage from each and every origin to each and every destination .... For the return trip from Texas a tonnage value of 0 will...

If you mean when you register, how long do have? No idea. I've rescheduled exams and pushed them out 6 weeks or so, and I imagine that you could continue...

Not really. You can use a CASE type expressions as

...

If @item = 'Job'

then

select

JobID = OrderID

...

It might not be something in red. I asked because the messages window in your image shows a long, small, scrollbar to the right, so there should be lots and...

Did you read the Books Online section on CDC? This is so open ended, it feels like you haven't done research.

We are happy to help with specific questions, but...

Keep in mind that 3200 people connecting to your application (web or thick client), don't mean 3200 connections to SQL Server. Usually those connections come and go.

However user connections don't...

Why create a local account? If you are in a DR situation, you will need to recreate things instead of using the same account.

Use a domain account. No rights at...

Did you scroll through all the messages? There should be something there. Did you click the yellow bar?

Load on prod? I/O path to the backup drive? Compression requires CPU. Is the prod server busier?

roryp 96873 (8/23/2012)

---

Probably because no one will pay attention to them unless they say something stupid. Half the time I think guys like Bayless and Limbaugh do this as...

That was cigars.

Lots of people overlooked that, thinking 1,000 values, 1,000 limit. I'd...