What's a #?

I think we want a couple ways to do things, things that are easy. I don't know that we can alter this editor very easily. The side shortcuts...

Quick clicks, for example, I typically type the code in, highlight, and then click "code" from the left.

This reminded me of a certain visitor to our forum recently: http://www.37signals.com/svn/posts/1768-i-dont-care-how-good-you-are-at-programming

Anyone want to guess who it is?

The PK (Primary Key) has nothing to do with a clustered or nonclustered index. It is a logical structure that gives you a field to uniquely identify a row. It...

If you rebuild a table, meaning drop the data and add it back, you get new identities. You can reset the identity, or not.

If you add the same set of...

I'd suggest you cut and paste a portion of the log that applies. I realize that you might be frustrated, or in a hurry, but your typing has a bunch...

You can easily enforce uniqueness with an index, identity or not. I think you're confused about what rebuilding the table means. It doesn't change the identities, or loose uniqueness.

Ok, moved back. Doh! Didn't realize this was a continuation of another thread.

One note, if you are not asking a question on the article, you want to start your own...

Moving to SQL 2005 - strategies. Please don't post in author's forums.

Now that is interesting, didn't know what. Worth of a blog post.

DNS and DHCP servers do need to respond quickly, but they have low resource requirements, and I've seen many people virtualize these easily.

Going to a VM doesn't mean your server...

#3 looks good.

For #4, what you want to do is set up a CASE statement. Are you looking for people in each group/range in one query or are you trying...

Ah, data file, sorry, no this won't help.

My apologies for not reading closely enough. I'll blame it on a lack of sleep, which is again, my fault.

If the data file...

It's a management thing. If you run them in MSDB, they are in your backups, and when you restore on another server, they are contained. In the file system, you...

Barry, interesting point. What if you can't "attend" unless you get the freebie?

I guess you will have to decline in that case to avoid the legal issues.