Your biggest thing would be to get someone from the UK to read through your CV and get feedback on that. A lot of times the agencies won't really go...

Are there any locking or blocking issues with regards returning the data? Is it possible that the proc is being called mulptiple times and blocking itself?

What does that line do?

Ah, ok, never used the windows load balancer (always been fortunate enough to be somewhere with network guys who handle that at the switch level).

example scripts.... http://www.sqlservercentral.com/scripts/contributions/1125.asp

Replication is an option, however you run in problems when you make changes to the schema on the publishing server.

Your best bet would be to use Log Shipping. This is...

Have you looked at using ISNULL?

select CONVERT(VARCHAR(8),date)) + ',' +

     ISNULL(text1, 'NULL') + ',' + ISNULL(text2, 'NULL')

If you explicitly name the columns in the select clause you could use AS for each column, ie

SELECT TABLE1.COLUMN1 AS [TABLE1.COLUMN1], TABLE2.COLUMN2 AS [TABLE2.COLUMN2] FROM TABLE1, TABLE2....

Why not set up a rule on your inbox to move the email into a seperate folder, then you can just look at that once a week, or whenever you...

Less to do with redundancy and more to do with trying to get the best performance. The backbone to the data center here is 100Mb, but we have a private...

If you are backing up using TSQL make sure that you use WITH INIT or you'll wind up appending to the previous backup. If through enterprise manager make sure that...

Yes you can defrag the files, however you do have to stop the SQL services while you do so. Afterwards you should defrag the indexes. It would be worthwhile managing...

Have you done this within a cluster?

I'd like to team the connections, 2 to Gb, 2 to 100Mbs, 1 private cluster

is SQL using all of the available free memory on the system (or that you have allocated to it)?

You don't have to remove it, however it's best to do so, so as you don't have stuff hanging out in the master db.

You might well not have created logins...

Add this to the master db, remove it when you are done.

CREATE PROCEDURE SP_AUTOFIX_USERS

AS

/* USAGE FOR FIX USER SIDS FOR ALL DATABASES

 SP_MSFOREACHDB "USE ?; EXEC SP_AUTOFIX_USERS;"

*/

-- Declare the variables...