THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » Performance   (RSS)
  • Heaps, forwarding pointers, ALTER TABLE REBUILD and non-clustered indexes

    Let's start with some background on forwarding pointers: Forwarding pointers in heaps can be a mess to get rid of. A forwarding pointer happens when you modify a row so that the row doesn't fit on the same page anymore. SQL Server moves the row to a new page and leaves a forwarding pointer where the old row used to be. This means that ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 28, 2009
  • Does the Resource Governor govern?

    Two weeks ago, we did the ''SQL 2008 Summit'' roadshow here in Sweden. We did 4 cities around Sweden in 4 days (http://www.expertzone.se/sql2k8/). It was a bit exhaustive, but even more fun - being able to travel and spend some time with persons wish I could meet more often (Kalen), others I meet regularly but only at workplace (Roger, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2008
  • Make sure you play with data collector on a virtual machine

    I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. In fact, I suspect that you in the end need to use some of the undocumented data collector ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 25, 2008
Privacy Statement