If it was never going to be more than a 24 hours worth you might try this.

SELECT LEFT(Convert(char,DATEADD(n,187,0),114),5)

However if it may ever exceed 24 hours worth you will have a...

Actually I think the assumption is wrong this

SELECT * FROM TblLog WHERE ISNULL(TblName,'-1') = ISNULL(@InTblName, '-1')

will not return the same as this

SELECT * FROM TblLog WHERE ISNULL(TblName,'-1') = ISNULL(@InTblName, ISNULL(TblName,'-1'))

First...

Take a look in BOL at "BackupDevice Object".

I think the random drawing is the best thing.

This will in many cases be the situation. However there can be various factors that can effect the performance. Sometimes you have to try it several ways to get the...

Take a look at the dump file and see if anything specific jumps out. Sometimes it does, sometimes it doesn't.

How often are you getting this? ANd have you looked for a dump file. There should be one created for this type of message I do believe.

I haven't tried but I think you could build by overlaying the extracted source for the SP over the strucutre of the original versions layout. They matchup as far as...

Read my article here

http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

SQL itself cannot define a single column as FK to 2 seperate tables. You have heard all the arguements as to why.

However that said, you can create triggers to enforce...

Consider one of the third party backup systems like SQLLitespeed (http://www.imceda.com/) or SQLZip (http://www.sqlzip.com/) which offer compression in the backup. They are very fast for local backups and the smaller size...

Concurencey of queries has a lot to do with hardware and design more than SQL's capabilities. You might try using Profiler to monitor the workload and use the Index tuning...

Look at MAXDOP in BOL.

Can you post your code with regards to the backup. Make sure you close any objects you opened just for the backup process.

Yeah, for that price you can buy several books and if you check on EBay can pick up dozens.