I love that I can still learn cool new stuff with SQL Server even after 15 years I was trying to troubleshoot a problem and got to the point where I was questioning everything I knew about backups/restores because I just couldn’t explain what was going on and why a restore was taking so long [...]
Posts under ‘Performance’
EDMPASS July Meeting w/Brent Ozar #YEG
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: [...]
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 [...]
