Derek,

Interesting and a nice argument.

However I'd argue that we need lots of checks in there. It can be the tools adding them, but we are more interconnected, there are more...

Well said, Manie.

What files do you have?

One thing to consider if you want the current mdf/ldf files is to install a new copy of the OS in a new folder, then boot...

I always wonder what those things mean next to the threads. I tend to ignore them.

Not sure I want a "twit" flag out there. As much as it might be...

I'm happy to entertain moderator nominations. It helps to have others that can move threads if they're in the wrong spot. I hate to have people censoring though, I'd rather...

I need to look at Google mail. I've heard it searches well, and it should. Right now my account is an archive where I send stuff I want to keep...

But it pays well. If I was going back to work, those would be the two areas I'd focus on.

The best tool is one that can do the job and you are comfortable and like working with.

Without more info, can't help more than that.

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...