I know that these four options are listed in Configuration manager under Protocols, but I wonder in how far "shared memory" can be described as a NETWORK protocol, since it...

The reason you can't find it in BOL is that this option was...

Yes, you can add the maxtransfersize to your maintenance plan.

Check this article for details:

http://support.microsoft.com/kb/873482

I agree with Steve. If you need replication then the firewall ports must be opened.

If merge replication is an option for you you can replicate via http using either...

Since you're using 2005, the management views can help you in optimizing your indexes.

This will show you if and how your existing indexes are used:

SELECT *

FROM sys.dm_db_index_usage_stats

ORDER...

Just add a filter to your trace which filters on duration > 30000.

You must use 30000 because the duration is measured in milliseconds.

What do you mean by that ?

I've been...

Actually I didn't look in BOL.

I have a short list of Tips & Tricks I often use in reports, and that's just one of them.

Sorry but I can't help you with this. I found the documentation in BOL not that good when it comes to formatting options. What I did a lot was looking...

SQL Server 2005 native backup can't compress the backup files, but there are several third-party solutions like SQL Litespeed, RedGate SQL Backup or SQLZip.

Alternatively you could call an utility like...

Brandie,

right-click on the textbox which contains your values and select properties. Go to the Format tab and in the field "Format code" enter the value "#,#".

This will format the values...

Did you by any chance changed the location for the errologs recently?

I once had a server there I changed the startup parameter and didn't noticed that it had a trailing...

Yes,

definetely change the AUTO_Close to false. My guess is that opening the datbase takes too long, so the backup process can't read the file and reports an error file...

From what you wrote I would say there's nothing wrong with the index. Fragmentation is well within the acceptable range. Maybe it's just not the best index to use ?

Can...

Your answer is in step 3: dbo or better said db_owner rights is needed for this. Except the jobmanagement part which is a bit tricky since jobs are stored in...