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.

Sorry, poor choice of words. No danger, no issues with integrity.

It works by building lots of small transactions to fill the VLF inside the log, then trying to shrink. Since...

Finally!

I added this to the shortcut list on the left as well.

That's very strange. No system DSN set up in control panel?

Is this NTAuth or SQL? I'm assuming NTAuth. If you log in, and try to connect, do you see a...