The leading wild card could be expensive as noted above. I'd also worry about users actually paging through the data causing a possibly expensive query to be run over and...

Jeff, thats a fair question. Dont know that my answer will do it justice, but here goes. I can see a few developers posting code bits, but you're right, probably...

The SSC timeout just ate my long winded reply - who built this thing anyway!

Not srue I agree with that. Replace "blog" with "easy way to post web content" and there are lot of situations where it makes more sense in the corporate world.

I think good blogs are pretty hard to do. Most of us don't solve interesting problems all that often, and blogging about something you read elsewhere isn't very exciting. I...

Lots of good comments and I agree with most of them - on both sides. If you want to have some fun, spec a simple form based app that will...

Politically and practically it's worth deploying Report Builder. Its hard to make a simple reporting tool that can do anything of value, but having it based on a model gets...

Jeff, I'll grant it is a simple topic - I figured by now I'd get clobbered by some statistics major for even using the word random! Maybe someone with a...

Andras, your method doesnt seem faster than just making the change in SSMS? Both techniques require a lot of repetition, I'd think less room for error using SSMS to make...

Agree on MS Press and Wrox, and Apress has one too. I'd start with MS Press, then buy another when you're moving along some.

Snapshot replication is different than transactional, just throws over a complete copy of the data, after that no changes are sent unless you send over the entire snapshot again.

I'd be...

Im sorry if I didnt make that clear, you're correct; can only partition in Enterprise (or Developer of course) edition.

Transactional requires not just a unique column but a defined primary key. The only replication option without it is snapshot.

Scope_Identity is usually a better alternative than @@Identity.

Drop a note to webmaster about article requests. Restarting the server is really a non event for replication, everythign just works and it maintains consistency. Adding an article can only...