TimChapman

Sort by: Most Recent | Most Viewed | Most Commented

  • EXISTS() and COUNT(*) tricked me

    So, every once in a while I really go brain-dead and do something silly that I laugh about later. This happened earlier this week, so I thought I'd write about it. I was working on a little presentation to a group of developers on writing performant SQL Server queries. I was in the process of writing an EXISTS() statement, and noticed that the execution plan didn't show the statement going out to disk to retrieve records. It was returning SUPER FAST. In my mind-set at the time, I thought...

  • Facebook Engineering

    I found a very interesting blog by the Facebook folks regarding some of their engineering challenges they've ran into here: http://www.facebook.com/notes.php?id=9445547199 One of posts there is about a technology known as memcached . They use memcached for a lot of thier database needs to scale out users, especially their new username feature. A great read of the feature is here: http://www.facebook.com/note.php?note_id=114979233919 So, that got me to thinking...how useful would memcached be...
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems