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 » Performance » SQL Server 2008   (RSS)
  • The Curious Case of the Optimizer that doesn’t

    The optimizer is the part of SQL Server that takes your query and reorders and rearranges your query to find the optimal execution plan. In theory.   In practice, that doesn’t always work out well. Often, the optimizer manages to come up with brilliant ways to execute a complex query very efficiently – but sometimes, it misses an ...
  • SQL Server 2008: Lock Escalation, INSERTs, and a Potential Bug

    Lock escalation is a funny thing. I've found myself on numerous occasions waging war against its concurrency-sapping existence, and rarely have I found myself wishing that it would work more aggressively. But there is a time and place for everything, and yesterday I discovered that a major change has occurred with regard to lock escalation in SQL ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 30, 2009
  • 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
  • Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

    It would be fair to say that there aren't a huge number of programmability features added to SQL Server 2008 that will have a great impact on most of our day-to-day lives as SQL Server developers. The release was clearly manageability themed rather than programmability themed, and I can count the most interesting and far-reaching developer ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 24, 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
  • Let's deprecate UPDATE FROM!

    I guess that many people using UPDATE … FROM on a daily basis do so without being aware that they are violating all SQL standards.   All versions of the ANSI SQL standard that I checked agree that an UPDATE statement has three clauses – the UPDATE clause, naming the table to be updated; the SET clause, specifying the columns to change and ...
  • Windows Server 2008 and SQL Server 2008 Benchmarks

    Microsoft released a document today with some SQL Server 2008 benchmarks I found this sentence very interesting The result demonstrates the scale-up capabilities of SQL Server 2008 on HP Integrity. The 10TB benchmark is so demanding that only six other results have been published in the nine-year history of TPC-H. More information on the ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on February 27, 2008
  • My Top 10 list for SQL Server 2008

    Long gone are the days when you can reasonably expect to know all aspects of SQL Server at a deep level.  When a new version starts to emerge, I try to put some scope around the features that I will dive more deeply into.  I'm publishing my list here so that like-minded SQL Server enthusiasts may become aware of a feature or ...
    Posted to Erin Welker (Weblog) by ErinW on January 20, 2008
Privacy Statement