Good point, I should have said that, we often group our backups onto maintenance plans just to make all the agent jobs clearer as to purpose - just make sure...

Just define normal backup jobs (to backup device or to file) on the instances as you would on any other instance - just make sure that the backup destinations are...

In the scenario you've given it is the application that is responsible for sending the traffic to SQL server so as long as the app is happy with the WAN...

Thank you.

thanks

So I'm not the only one thinking the options given are wrong!

I know it's not really specific to SQL Server but in my experience developers are often forget that someone has to use their end product so they make too much...

That's interesting - is tempdb not used at all in data loads - I've had problems here recently with large dataloads and tempdb so I'm surprised to hear that.

It is worth stressing that the tempdb files should be the same size as each other if you have multiple files.

Good point - more spindles is good so make sure your datafiles, logs, tempdb are placed separately if possible and then start thinking about your operating system paging file, available...

Have you looked into setting the database in bulk-logged mode.

Inserts are certainly quicker without indexes so if you can avoid indexes until after the data is inserted - that will...

Spotted it.

Silly me - opening the properties of the data row showed me the "hide duplicates" option which was exactly what I need.

For a conversational starter I have a list :

- Adjusting my chair - other people use my desk when I am not there, we have a large transient population, no...

Laptops are great - I'm sitting here using wifi at home to a citrix work login and USB sticks have been a revolution (I'm going to fix a laptop tomorrow...

I started down that line but found that didn't give me everything. I now have stored procedures for

1) Identifying if a backup job exists on a database - we...