Msaurez, no idea. What version of SQL? What type of replication? If transactional, vanilla, updatable subscribers??

Jeffrey, the schema idea is interesting, it's just felt like it was worth doing to me, all too often users need to cross schemas to get work done. Have you...

David,

I like the approach, but be open to other options if it seems like that is what the company needs. For OLTP as far Im concerned it doesnt get any...

Ross, I tried multiple ID's and the only way it worked (for me) was to have separate machines, one logged in as powerless me, other as SA me. Trying to...

Thanks everyone! Charles, that's an interesting use of an idea - the best part about content on SSC is reading the discussion that goes with it!

Thanks Mark! Absolutely restarting the service is a valid shortcut if you can afford the few minutes of down time.

Andy, nice post, better than mine I think! I've grown to like the idea of translucency over transparency. Everyone deserves some degree of privacy, and ideally they set it themselves.

I'll...

LinkedIn is one of those services I want to like/use effectively, just don't see how yet. I have a few friends that find it useful in the consulting business; if...

Thats correct. MS has a whitepaper on it, stats get updated when you go from zero to not zero rows, when it crosses 500 changes, and when it crosses 500...

Have to find the tipping point. Drop/create may or may not be faster, for example if you are adding 1 million rows to a 100 million row table. The other...

Chris, thanks for the correction on the NC index, don't know how I missed that!

ETL still seems like the best scenario, only because there's sort of less work to do...

Bill, on the round trips I should have said per word. Think of typing in a forum post, if every word is a proc call, thats still verbose. I'd say...

My concern would be the number of round trips that might get generated. Other than that, I've always used a 3rd party spell checker (including the one in Word at...

I'm not a fan of maintenance either, and skipped it on a regular basis as a manager. Maintenance comes in two flavors, minor upgrades/bug fixes (which I'm not inclined to...

Steve, as far as the term limits, just because you move a few people out is no reason to lower the bar. Say you have 200 MVP's and you push...