Either will work, but the reason Compact uses less resources is that it isn't a server. You would need to write some application or have a host process that can...

I delete anywhere from 10-50 posts a month from SPAM, so those are likely the issues. I believe this column is an identity, so deletions lead holes.

yes

David,

Very interesting points. Interested in walking through an article or two with a real system? Maybe something like SSC or a blog site and do a data model?

Now this is beautiful

http://www.sqlservercentral.com/Forums/Topic996707-392-1.aspx#bm996724

Should make that the model for how to ask questions

Alvin Ramard (10/1/2010)

---

I used to work with a guy with the last name Wong. We kept joking about him looking for miss Right and turning her into Mrs Wong....

amenjonathan (10/1/2010)

---

Personal rant about blogging is how long it takes. I'm already reading SQL mags and studying for a cert, and all this after putting in 40+ hours per week....

My Mom used to allow us to open one present from the family on Christmas Eve, with Santa bringing other stuff the next morning that wasn't under the tree that...

Roy Ernest (10/1/2010)

---

I just wanted to let you all know that Jeff Moden gave a great presentation for our user group yesterday using Netmeeting. Everyone loved it. And they like...

Brandie Tarvin (10/1/2010)

---

GilaMonster (9/29/2010)

---

Kit G (9/29/2010)

---

Because a woman couldn't possibly be wrong and therefore whatever she came up with would work...

Jeff Moden (9/30/2010)

---

A couple days? Without it going bad or sour? Hmmmm... I may have to get one after all. You didn't happen to get it from...

I think it's an int, might be a big int, but we should be fine for years. Surprisingly, a million is a big number when it comes to forums.

Isn't that your "white oak therapy" time?

I have emailed him before, banned him, removed his account, etc. He comes back periodically, so I'm not sure I can do much good.

I'll ping him about this post.

He...

Do you have a witness on those databases?

The list above is pretty good. I would search through the SQL server error log and look for anything that occurred right before...