A SPID blocking itself is actually SQL Server's way of showing that a SPID is waiting for I/O to complete... these never used to be shown in sysprocesses/sp_who2 until SP3...

Using JOIN is considered better for reasons of standardisation and readability, not performance. For a simple query like yours, you will see no difference in the query plans.

Using JOIN is...

Sounds like the old problem where space release by deleted/modified image or text columns isn't released.

Have a look at this KB article http://support.microsoft.com/kb/324432

It might be worth running perfmon to see what your I/O speeds are.

My previous experience with index defrags were that they just ran nicely in the background without interfering with...

Your job is trying to store the value 48490 in a...

More than 1 way to do it, but I find the easiest to write is:-

SELECT getdate() - 0.5

This subtracts half a day from the current date

Have a look at the date on those 2 missing records... I suspect there will be a time portion to the date.

In SQL Server, if you don't specify the time...

What resolved our problem was to add a SessTimeout setting with the DWORD value as 360 to the Win 2003 or Win2K registry on the SQL servers that the backups...

You should find it in the :SQL statistics object

As per BOL:-

Right-click the database you want to use as your primary database in the log shipping configuration, and then click Properties.

Under Select a page, click Transaction Log Shipping.

Clear the...

The backup will as at the END of the backup (SQL Server actually appends to the backup file, any changes made since the start of the backup).

I believe the ability to do this is limited to the Enterprise Version of Visio

No, I meant what I posted.

charindex(',',name) will give you the position of the comma, and the -1 backs it up by one...

CHARINDEX is what you are after:-

select substring(name,1,charindex(',',name)-1)

Switching compatibility does nothing more than restrict/enable the ability to use certain TSQL enhancements added in SQL2005.