Im in favor of images and similar things in the db. It's not as bad as most think. As just for fun, ever try to open a folder that has...

You can go beyond 4k if you use exec(), you just have to do something like exec (@sql1 + @sql2 + ....).

Compare (diff) tools are a good way to generate...

I'd enjoy a separate mailing.

It would be useful if one section contained a list of all new threads created during the previous day, and maybe a reply count - I...

I havent been the contrarian lately, so....

I tend to use NOLOCK frequently, but I don't write financial apps and I generally understand the data movement that might occur. I think...

Dont get too hung up on the exceptions. You're right that it won't work 100%. The question is, is it useful at 90%? At 80%? I see too many solutions...

Might also consider changing permissions on the subscriber so that users can't delete records there.

You only need the column if you're doing updateable subs. The easiest way to get a refresh of a subset of your names would be using snapshot replication (or transactional...

Agree with Dclark, its not that many records. Design the table well and figure out which columns to index, build from there. If you need an archiving strategy, build that...

You do have to drop it manually, shouldnt hurt to do so as long as you've removed replication. Its only used by updateable subs (unless some programmer has decided to...

Its often useful to get a ratio of m/f in a list to see if it meets you needs (when buying a list that is). I've used the table lookup...

Nice work. I knew a proc could get split across multiple rows, just never ran into the scenario you describe where the word is split (or I ran into and...

I live near where I was born as well. I've seen some other places I liked but none that I liked so much I wanted to move there!

I think I'd vote for the 8lb sledge hammer, good exercise and showy results. Or I could picture something like one of those  hydraulic presses they use on junk cars,...

Steve, you going to comment on the lifestyle change?

Yes, a storm indeed. But a surprisingly pleasant one this time. With experience I see more gray and less black/white in the world, and I think that opens some interesting...