On July 7th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below: http://www.eventbrite.com/event/686883487 Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. Date: July 7th 2010 Time: 5:00 pm – 7:00 pm Location: Stanley A. Milner library Map: [...]
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 [...]
