August 2008 - Posts

• Large Query Performance and Query Parallelism

  [ 2008/08/25 ] This post has been modified significantly to correct some inaccurate statements because I mis-read Joe Chang's post. Joe Chang posted some interesting results using the TPC-H queries with the scale factor set to 10. I happened to have done Read More... Posted Sunday, August 24, 2008 2:32 PM by Linchi Shea | 13 Comments Filed under: Performance, Testing, SQL Server 2005, Benchmark

• MSIZAP is Your Friend

  If you ask for my opinion on Windows Installer, I’d have to think what polite words to use. But almost every Microsoft product uses it, and that includes SQL Server. So we are stuck with it and have to live with it for now and for the forseeable future. Read More... Posted Tuesday, August 12, 2008 12:18 PM by Linchi Shea | 4 Comments Filed under: Tools, Rant