Is "DevTeach/SQLTeach (Toronto, ON, Canada)" the right link? I do not see the schedule for Toronto in 2009? I did see the archive of 2008.

I noticed that during SQL2008 backup with compression, the backup file size is doubled until the backup is completed. For example, a database sized 10 GB with the final...

Thank you. That helps me to figure out what was wrong.

I am backing up the database not the data file. I used SQL native backup, backup with compression, and even litespeed backup, either through GUI or T-SQL, no luck....

No risk, no adventure/gain. Risk causes loss. But loss is kind of gain.

From time to time the leader has to make a change even it is risky. ...

Thank you for pointing it out. I tested both using 1/2 million records. Your query is 2+ times faster than the query using stuff/convert.

I doubted the conversion cost...

My test shows 50% : 50% execution plan cost for these 2 codes.

create table mytest (mytime int)

insert mytest values (91700)

insert mytest values (212000)

insert mytest values (90200)

insert mytest values...

Stuff takes character_expression. Need to convert int to char first.

select stuff(stuff(right('000000'+convert(varchar(10), mycolumn),6), 3,0, ':'), 6,0, ':') from mytable

a bigger one from last year: 100TB+ Scientific VLDBs with SQL Server 2008

http://www.softconference.com/pass/sessionDetail.asp?SID=136207

Thank you Ken. It works for database mail (SQL2005), but not for SQL mail (SQL2000). I also need to find out those info from SQL2000. Any idea?

Try DBArtisan (free trail) to script login/user. Not sure whether the new version supports SQL 6.5 or not. The old version does.

It depends on your own environment....

This may help.

http://www.sqlservercentral.com/Forums/Topic514288-357-1.aspx

This reminds me a few years ago when I was involved in a tape library upgrade.

Where to keep the old backup device and software? If need to...

One more add-on:

Try to set up the requirements for database support on your side, including server version/patch level, user access, SLA agreement (if any), etc. This could be a...