AS a DBA who uses SQL 7, and SQL 2000 as well as Oracle 8i for our ERP system, I can only say that I find that there is not much...

When you have worked out what indexes you need if at all possible place them on a different disk to your datafiles, with your log files on yet another disk...

ListenOn connection '1433' is already in use..

was recorded in log.

Firstly you need a unique row identifier for each row add an identity field

SELECT * 

From yourTable

WHERE Operating_System = '2000'

AND Processor_Speed  >=500

AND Location <>...

I'm not sure where you are getting your list of postcodes from but could you not use DTS to import the list into a table ??

You could use SQL DMO.

BOL is Books Online (SQL Help files)

IN should only be used for short lists. It is not very efficient. Put the list of postcodes into a table and inner join to your indexed postcode column on...

Bill is right DTS is the way to go.

Very powerful, yet simple to use. Its always my first port of call for any SQL import/export issues.

Life is short, too short too worry about the pronounciation of SQL.

This should be part of your disaster recovery planning.

A database will be marked as suspect if any of the following conditions is true:

ƒÞ If one or more database files is...

Strange... but if the Differential backup is so large does it take a long time to do (longer then a full) and likewise with the restore?? If so why not...

Version control?

I've seen production servers where retrieving an older veriosn of stored proc. would mean getting the backup of the night before and recreating the database.

BE 100% sure to test sending emails with Lotus while logged on as the account that SQLServer will use to send mail before going near the actual SQL Server configuration....

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

This is the least restrictive available. You may see locks still in Enterprise manager Management -> Current activity -> lock/process Id but that is too...