Personally, I wouldn't want to work for a company that ranks potential candidates based on their Credit, BMI, or Social Media score. How HR and the hiring manager conduct the interview...

Within the next five years, knowing how much memory is installed in the server(s) your query is running on will be about as relevant as knowing how many cubic centimeters...

While there is some marginal CPU overhead, from what I've seen, data compression actually doesn't explain high CPU utilization.

If you havn't done this already, I'd suggest confirming...

Some software publishers will add ping back features to their apps, and e-books often contain digital watermarks that are unique to the account that originally purchased the product, so they...

Steve,
Have you ever published an architectural overview for SQL Server Central, similar to what other websites like Stack Overflow and Netflix do?
Also, while the hood is up,...

Performing transformation in the SELECT is OK, but staging the data to a table and then performing UPDATE(s) is a waste of time and disk space.