Thanks for the updated URLs. Fixed the announcement.

And thanks to everyone that voted!

You can detach, move the log file, re-attach, pick both files from their respective locations.

The problem with the committee is the load and getting things reviewed. We've tried a few things over the year, but it hasn't worked well.

We'll never stop the complaining, and...

If you mean the computed column, you'd define that in SQL Server as the combination of the PK and another column or a static value and that goes into a...

Thanks, bitbucket. It is hard, and it's really hard when "making up" answers to not collide with something in BOL. I was sure that calling something an "optimizer hint" was...

You aren't joining the two items together.

A CTE behaves as a table. If you have 2, you've defined two tables to use in a query. The query still needs...

You could use a GUID, which would keep things separate, though not terribly readable.

You could also use a computed column, take the PK, add an "A", "B", whatever to it.

I...

Actually, you just need to know what they'll pay for 😀

Lynn has a great point in that you need to know what your recovery intervals are and what your tolerance is for lost data. Based on that, you have to...

What is working and what is not working, or maybe you can explain with some data what you want to happen. It's a little confusing as to what you think...

I would highly recommend you stop using one file for all your backups. If something happens to that file, a corruption or anything, you lose all backups in there. That's...

You can restore to 2005, but not 2008.

However, you can restore to 2005, it will drop into 70 mode, then take a backup as a 2005 backup. That should get...

Low disk space will slow it, but I'm not sure it should be hours. Is the server overloaded?

says here you can do the restore:

http://msdn.microsoft.com/en-us/library/ms187495(SQL.90).aspx

Not sure what incomplete means. This?

http://www.eggheadcafe.com/software/aspnet/30578212/restore-problem-the-m.aspx

I've never really used it, but I recently read a book that recommended it and I agreed. I'll use it from here on out.

It's a good habit to get into...