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 » internals   (RSS)
Showing page 5 of 14 (137 total posts)
  • Query Optimizer Deep Dive – Part 3

    This is the third part in a series of posts based on the content of the Query Optimizer Deep Dive presentations I have given over the last month or so at the Auckland SQL Users’ Group and the SQL Saturday events in Wellington, New Zealand and Adelaide, Australia. Links to other parts of this series: Part 1 Part 2 Part 4 Storage of Alternative ...
    Posted to Page Free Space (Weblog) by Paul White on April 29, 2012
  • Query Optimizer Deep Dive – Part 2

    This is the second part in a series of posts based on the content of the Query Optimizer Deep Dive presentations I have given over the last month or so at the Auckland SQL Users’ Group and the SQL Saturday events in Wellington, New Zealand and Adelaide, Australia. Links to other parts of this series: Part 1 Part 3 Part 4 Cost-Based Optimization ...
    Posted to Page Free Space (Weblog) by Paul White on April 28, 2012
  • Query Optimizer Deep Dive - Part 1

    This is the first in a series of posts based on the content of the Query Optimizer Deep Dive presentations I have given over the last month or so at the Auckland SQL Users’ Group and the SQL Saturday events in Wellington, New Zealand and Adelaide, Australia. Links to other parts of this series: Part 2 Part 3 Part 4 Introduction The motivation ...
    Posted to Page Free Space (Weblog) by Paul White on April 27, 2012
  • SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

    One last reminder -  If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday.  Full details are here: http://sqlperftuning.eventbrite.com/.  We'll be working some exercises, so bring your laptop with an instance ...
    Posted to Kevin Kline (Weblog) by KKline on April 23, 2012
  • Fun with Aggregates

    There are interesting things to be learned from even the simplest queries.  For example, imagine you are given the task of writing a query to list AdventureWorks product names where the product has at least one entry in the transaction history table, but fewer than ten. One possible query to meet that specification is: SELECT ...
    Posted to Page Free Space (Weblog) by Paul White on March 11, 2012
  • Reading temporary table from another session

    It happens to me at least once a week – I want to check progress of some heavy script that runs in chunks over big dataset and find out that it writes intermediate data to temporary table only. Last time it happened 3 days ago when I wanted to analyze 50GB trace table on my notebook. I wrote a script that was taking 200 thousand rows at a time, ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on March 1, 2012
  • Forcing a Parallel Query Execution Plan

    This post is for SQL Server developers who have experienced the special kind of frustration, which only comes from spending hours trying to convince the query optimizer to generate a parallel execution plan.  This situation often occurs when making an apparently innocuous change to the text of a moderately complex query; a change which ...
    Posted to Page Free Space (Weblog) by Paul White on December 22, 2011
  • Geek City: Growing Rows with Snapshot Isolation

    I just finished a wonderful week in Stockholm, teaching a class for Cornerstone Education. We had 19 SQL Server enthusiasts, all eager to find out everything they could about SQL Server Internals. One questions came up on Thursday that I wasn’t sure of the answer to. I jokingly told the student who asked it to consider it a homework exercise, but ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 19, 2011
  • Did You Know? I’ll be teaching my Internals Class online!

    In my most recent commentary for SQL Server Magazine, online here:http://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429, I talked about different options for making training content available online. As an addendum to that, I’d like to mention that one of my training partners (Benchmark Learning in ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 7, 2011
  • SQL Server, Seeks, and Binary Search

    The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks: In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later).  ...
    Posted to Page Free Space (Weblog) by Paul White on August 8, 2011
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement