C #7 Cafeteria. I don't mean just a room with chairs, tables, and a vending machine; that's a break room. I'm talking about a real cafeteria serving fresh hot meals...

The ALTER INDEX statement supports an optional PARTITION clause. This is useful if you have very large tables, allowing you to REBUILD or REORGANIZE one partition at a time or...

Job satisfaction is multi-faceted issue: Pay / Commute / Comradery / Career Growth. You can leave a job in search of one facet only to discover that you've ultimately lost...

Hi Ben, I like this topic, but I'd just like to point out that half of the paragraphs in your article are repeated.

Generally speaking, you're going to take a performance hit when applying ranking at runtime, especially if you're joining on a ranked sub-query. Optimal indexing helps, but I'd suggest adding a...

I wonder what is the oldest post on SQLServerCentral?

Am I understanding correctly that there are multiple sources, and for each separate ETL run, the source of each column in the destination table can be different depending on a...

I've been involved in all variations of deployments, most of which involve databases for which I did not originally develop. But like I said five years ago, if you have...

OK, it's a bit late, but here is a good one.

Logitech Introduces High-Resistance Keyboard For Fitness-Minded Typists
http://www.theonion.com/article/logitech-introduces-high-resistance-keyboard-fitne-55710

Perhaps the best way to tactfully brush someone off when they are peering over your shoulder is to strike up a conversation about a mundane or personal topic for which...