Authors work hard on these books. Pirating them or downloading them for free when the author has not agreed is wrong. You want to get paid for your work; pay...

You should read through the physical storage architecture sections or BOL or pick up a copy of Inside SQL Server.

If you have CHAR, then the space is saved in the...

I'd script it out and then save the script. You can easily search and replace the server names or database names if needed to rebuild replication.

At TechEd this morning, they are giving away lots of DVDs with RC0 and the rumors are still a Q3 RTM, so things must be very close. I've seen the...

Most consistency errors are raced back to hardware problems. Potentially fabric or controller errors could be present.

I'd be sure that someone carefully runs diagnostics on your storage.

This is really a scripting problem. You can host this in DTS, but you'll be writing VBScript that can be run from the command line as easily as tucked inside...

SP2 had an issue and there were updates postSP2 that corrected issues with this task.

Jack makes a great point. Often the person that pushes the project through or gets it approved doesn't use the system. They "think" that people need something new, and if...

You can reply to a previous thread or topic and post an answer that way (or a new question).

The linked server syntax is four part naming, so server.database.schema.table.

Haven't heard of anything. What does the package do?

You might need to call Microsoft support for this.

What are the steps?

In the job properties, is each step set to move to the next step on completion? Are the jobs the exact same jobs in both instances?

You could...

Agree, add the user to the role rather than aliasing.

You can set the Execution Plan on in SSMS and check the costs yourself to see the differences.

We definitely need a GUI for Service Broker. I'm not sure one's coming in SQL 2008, but there is a lot of work being done on the manageability and tools...

Sorry, the link is fixed.