Went and returned. No rest for the weary.

microseconds, just in case anyone else can't find it.

BOL can be hard to read. I would think they'd have included an abbreviation "mu" for the reading as well.

I'm a fan of blogging, and I think it helps me think through things, get ideas, and ensures that I understand things myself when I go to put them down...

From CSS: With TDE, limited Backup compression is achieved.

http://blogs.msdn.com/psssql/archive/2008/03/24/how-it-works-sql-server-2008-backup-compression-database-compression-and-total-data-encryption.aspx

So much for "ignore this"

Five bad jokes? That's it? I come back from a day of vacation to 5 bad jokes and a guy that should stick to using Excel to store data?

I'm on Peak 7 at Breckenridge.

If the IRS can find...

I don't think I ever have any effect on that happening.

I'll pay in a month...

Happy Tax Day, and behave children. I'm going skiing, so no one will be here to moderate bad jokes and subtract points.

Flat tax, I like that one.

Seth's answer should work for you. Note that ordering isn't going to matter here to SQL Server. You would need some ORDER BY clause to get data back in a...

Well that's good to hear. I think we're cluttered. I'd like a cleaner, more open Stack-style interface here.

Ahhh, dreaming of the day I'll get development resources...

I think you need to write this out with some sample data, and explain how you get those values. What is the second table? The new one? Is the first...

Don't grant rights to users. Use roles. You can create your own with these rights, using the commands above, and then assign users to roles. I'd do two roles. One...

In 2008 there's a trace flag (http://msdn.microsoft.com/en-us/library/ms188396%28SQL.100%29.aspx) to stop those messages. Not sure there's a way in 2005.