This post needs a big reply, rather beyond me I'm afraid.

A few points, however:

- I'd go for RAID 0 + 1 it's far more write-efficient than RAID 5. Definitely worth the extra...

This is a leftover from pre-EM days. It's a reminder that you have to run RECONFIGURE WITH OVERRIDE for your configuration change to take affect.

The full syntax in query analyzer...

I implemented a 'home made' log shipping solution for my company's Disaster Recovery environment after I found the official SQL Server one to be too inflexible.

Basically I use a combination...

Another belated agreement but what was true in 2002 is true now.

The practice may have seeped over from Oracle where application objects are usually owned by a specific user (sys...

Andy Warren - 5701 posts ??!!??

A useful reminder of an old and under publicised stored procedure. Microsoft seem to be 'suppressing' sp_addalias in favour of roles but as you say roles don't always fit the bill. I...

Your script looks good although the TRUNCATE_ONLY breaks the log sequence but then you've coped with that by backing the db up immediately afterwards.

Maybe add the DBCC SHRINKFILE as an...

You have to install the Pervasive client software on the box running the SQL Server then set up an ODBC DSN to the Pervasive database. You should then be able to...

I tried adding indexes to both columns of both tables but always ended up with a '2', but then I guess an index will always order as 1,2,3 etc.

Good question though.

My guess is that setting the web page to windows authentication means the CONST definition is ignored. The page tries to connect using Windows authentication and your Windows login is...

Differentials can only be restored over the last full backup, there's no way around this.

Your options are:

(1) Don't do full backups outside your weekly schedule. Ad hoc differentials are OK...

I reckon SQL Server's backup & restore capabilities are excellent and easy to use (have you ever backed up an Oracle database??) so don't reinvent the wheel. Back your dbs up to...

Well, I didn't know that! Better rewrite our hundreds of stored procedures now

Why the reference to OLTP (Online Transaction Processing)? Surely it would...

You can use a combination of SUBSTRING and PATINDEX to get to the first number in the string.

PATINDEX accepts ranges as a search expression in the form ' %[from-to]%'. This can...

I would retain the function as a stored procedure. Moving processing outside SQL Server will introduce more windows for error, esp. if you're moving large result sets to & from...