Unless this is something that PSS suggested be enabled for a specific issue, I would turn it off.

As a proof of concept, you may want to turn it off in...

IMHO #2 is the only one that changes somewhat. For #2 you will possibly be looking at language differences and character differences.

I typically remove this type of stuff. It seems to have no ill-effect and I have not been asked by PSS for these folders.

If you are concerned about them,...

From Technet at http://support.microsoft.com/kb/318605

If the Force Protocol Encryption option is turned on on the server by using the Server Network Utility, communication between all clients and SQL Server is encrypted....

In addition to what Braindonor has said, please post table structure and actual execution plan with your specific questions. Doing this enables forum members to best help you.

smithsp17 (12/21/2009)

I'm trying to set up transactional replication between 2 transactional database instances, both SS2005, but am new to this. If I understand correctly, I set up a distributor...

Hey Iron Chef, did you remove the query? I see no query in any of your posts. Just curious.

Why not just use char datatype? Are you just pulling the value from the database and then using the app to render the color based on the value in...

For assistance with this, we need to have the table structure, index structure and actual execution plan.

Please post this information to help us help you.

IMHO, SSIS will be slower for this kind of process.

As homebrew said, you could use the GUI to script the changes. And then run them from the server itself.

Also,...

To restore the other system dbs, no. You only need to restart in single user mode for the master db.

http://msdn.microsoft.com/en-us/library/ms190679(SQL.90).aspx

We actually run a cluster with An active node per Instance. Node A has one instance and Node B has a different instance. Performance degradation is minimal when...

which is what exactly?

Anybody celebrate Boxing Day?

I think it is MMA Day here in the states these days 😀

http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx