In the setup, where you select the components you want installed, the install path is changeable down the bottom. You can also specify to put the data files in a...

Assuming you're on SQL 2005,

1. Set up database Mail in SSMS (this needs an SMTP server)

2. Run sp_send_dbmail in your stored proc

Hi,

A couple of things that come to mind

1. Code optimization - this might not be something you can change if you run proprietory software but check what the application...

Have you tried creating an individual backup job for each database? This way they can all run in parallel rather than having 1 job which backs them up sequentially.

I found these useful...

Building a cluster in Windows 2003

Installing SQL 2005 on a cluster

You might find it a little difficult to work in the UK unless you find a company who wishes to hire you that needs to prove they can't find a...

Hi Neil,

Is your index in question prefixed by a t? I had the same issue this morning where a showcontig was returning indexes that I couldn't see through Enterprise Mgr....