Negatives because things are being calculated and added to other things and probably overflowed.

Because a reindex is transactional, the system has to keep copies of the old and new pages...

The connection worked fine for me with credentials Chris supplied, so I'm guessing there's some firewall or limiting factor either on his network or elsewhere. I sent some screen shots...

This is not a question we can answer here easily. Go to Microsoft's site and look up the differences overall.

If you have specific questions, feel free to post them.

:), It certainly shouldn't be.

Willing to do a test if you like. If I mess it up, feel free to post a complaint here where everyone can see it 🙂

Hopefully they'll make some changes and we'll see.

I first saw BI, or what was called either DSS (Decision Support System) or EIS (Executive Infromation Systems) in 1990. We used those...

Ed has a good point. I'd also ask the hosting company if they allow direct, 1433 connections from your local PC to the remote SQL Server. They might not.

In terms of CPU drop, is that between the two boxes (old and new) or after you set max memory?

Not sure about L3, have to ask someone else about that,...

I'm not sure we want a information sharing section. All of the content here is shared by people and we bring it to light in the daily newsletter. The scripts,...

Sorry for the delay, Chris.

Let me try and explain how this works and then maybe you'll see a hole in what's happening.

When you install SQL Server 2005, it runs on...

Or you just administer your plan and specifically choose those databases that need to be backed up.

This is definitely something that can work, please however explain what the issue is using better English and not just shorthand. It makes it hard to determine the issue.

What is...

What was the connection problem and what did you see in the drop down for compatibility option?

Also, you did an in-place upgrade?

I'll look around on the old instance for the scripts tomorrow (late now 🙁 )

I'd think about potentially separating out some log backups to separate drives to spread the load...

As mentioned above, create a maintenance plan to backup all databases to your new drive and don't worry about it.

The backups run sequentially, but they tend to run quickly.

I'm not sure 300GB qualifies as a VLDB anymore. I think you need to be 1TB and above.

I wouldn't separate out varchar(max) content out to separate filegroups. No benefits in...