I don't see anything wrong with reviews, as long as labeled as such.

Nothing wrong with that approach. If you're really curious, you could compare the time it takes to just dbcc indexdefrag vs the complete rebuild that happens when you add the...

Interesting. I've mostly used model 1 as referenced, and for small/medium operations it works just fine. I see a lot of value in a diff tool for change detection so...

For debugging, try running sqlagent from a command line instead of as a service. I think it has a -v switch that will dump all the output right to the...

Should have added that to the original post, my apologies. I like the sequentialid change, just not sure I'd bother with changing old data (which usually affects other things, but...

I think maybe a better title would have helped, it really does feel like a review. Nothing wrong with a review and in the course of that I'd expect someone...

I've always made it a practice to have the dbo set to SA, but for the most part it doesn't matter, as long as you're ok with whoever the owner...

Not sure I agree with what you're doing, but maybe this will help anyway! How about creating a temp table that has a new guid column that defaults to sequential...

It did feel like a homework problem.

I'd go with the second solution, with one change, adding a comment to indicate what the value of 1 means:

SELECT c.fname, c.lname, moc.value AS PHONE