Rotating Header Image

Posts under ‘Performance’

Just cause it works… doesn’t make it right.

OK so the title might not be very specific so I'm sure I'm breaking some rule about how to be a “successful” author… but if I can get a bunch of people on April Fool's Day “Rickrolled” I'm hoping enough people will read on. In SQL there are so many ways to solve the same […]

Performance Tuning – Level Playing Field

When you’re performance tuning T-SQL one thing you want to make sure is that you are have a consistent environment to test your changes/modifications.  Two commands that will help ensure that your environment stays close to the same for each iteration of your script are DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE. Now for all those people testing […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.