Mirrored on this same server? I'm worried that the firewall or network is limiting the comm back from the DR server to the production server. That's why I'd test a...

I saw a produce recently that would move SSRS into Silverlight, so I'm sure that it is used as web reporting. It's that I don't know anyone touting it as...

Are they saying they have a hard coded connection string? I'd ream the vendor if this is the case.

The alias could be anything. You give it a name and then...

I don't see a logical reason in there either. Have you tried grabbing @@TRANCOUNT in between all the try..catches to see if it's actually being increased and you have an...

I would lean towards a bug, or a network issue. Can you try this? Create a small db, say 1MB, mirror it to the DR server. Create a table in...

I'm curious why SIMPLE mode. It's usually a bad idea.

As far as specs, it's hard to know unless you know what SQL is being run. One person on the box,...

I agree with Lynn. A SELECT might blog an insert/update/delete from committing, but that doesn't mean more log records. The SELECT is not logged.

I can start a tran, do...

Get lots of memory, and fast I/O. Beyond that, you need to examine code carefully and test. I'm not sure we can give you general tips without more details, or...

What doesn't work for you? Have you checked out FineBuild for SQL Server (http://www.codeplex.com/SQLServerFineBuild/)?

SSIS doesnt' connect to anything. The packages have connection strings. You can possibly set up an alias and aim it for 1433, or an FQDN in DNS and then point...

What advice would you like? What are you confused about? There are companies using Teradata, lots more using SQL Server.

It's not a good or bad move, it's a "what do...

Likely it's a Powershell add-in issue. I'll see if I can get some visibility to this.

I typically would look for INSIDE SQL SERVER for the best explanation of how this works. It seems to me that there was good information in there on how the...

Likely there is no one answer for how to fix this.

Connect is the place to raise this, and then post a link here, on your blog, etc. Try to get...

You could use a series of CTEs to help you. Each one could contain a query that you've written and then join them. This is a good CTE intro: Common...