If you back it up using disk or tape via arcserver/backupexec, the software will compress the backup file onto the selected storage device for you. If you need to copy it between servers then you...

I'd just like to add my two cents.

Zia method's is the one I use. If you attempt a date convert on the where clause, you will cause a sql to...

If NULL is a legitimate value ie. (NO VALUE), 0, 1, 2 you can use the COALESCE function to get the result your looking for. ie. the following example return's...