My apologies for this article. It was skimmed, but not thoroughly edited and it slipped by.

It also appears to be a copy of another article, so we have removed it...

Moving to data corruption.

One thing I'd try to do is script out as much as possible before you mess with the db. Once you get things scripted out, you're in...

Personally I dislike labeling things bad and good, especially with code since it's a question of where and when things make sense.

As I get older, I see less black and...

I haven't heard anyone reporting memory issues from SP3 at all. The only thing I've seen with SP3 relates to installing with a cluster.

My guess is that something else must...

You cannot "change" a login. You will need to remove the login and then add it back as a Windows login.

It doesn't affect logging in. It's possible that you can't access a table while the index is being rebuilt if its' the clustered index, but it should appear as a...

It's not really clear what the error or issue is. Whatever you do with PGP, you should be able to do with the command line. Once you can execute things...

Excel automatically adjusts data types and precision to handle different values unless you set the number of decimals. SQL Server doesn't act like that. You'll get implicit conversions that might...

It was a great session with Paul and the art of negotiating is something that everyone could do better with. It is definitely important, not just for tools, but also...

Check that the services are running, check that your firewall is not preventing connections.

You should spend some time learning about SQL Server and it's structure. Look in Books Online for logical and physical architectures.

There should always be free space in the database as...

Management Studio. Unless the SQL Server instance is on your local workstation, you are always managing permissions remotely.

I'd start with Books Online and get the basics from there. They have a good overview.

We have a lot of articles here: http://www.sqlservercentral.com/Articles/clustering, and there are some good videos here...

Do you mean that if there is a quantity of 3 for the it items, you need to insert 3 rows into order details? Are these the same rows? What...

The first few queries after a reboot should have a lower ratio.

I haven't seen anything reported on this before. Do you know what the ratio was before, 91%? 95%?