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 » Tips   (RSS)
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • Microsoft Windows Platforms Blog Watch

    Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
    Posted to Kevin Kline (Weblog) by KKline on July 20, 2011
  • New on SQLMag.Com: Update to SP_WHOISACTIVE

    I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time.  Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2011
  • Old Performance Tuning Recommendations Die Hard

    It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own.  In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how many times you shoot them, they just keep coming back.   Here’s a good case in point, ...
    Posted to Kevin Kline (Weblog) by KKline on June 23, 2009
  • Architecture Questions - What's Your Opinion?

    I had a great time speaking with the large communities of SQL Server users as I traveled about Europe last week and much of this week.  I'm always impressed by the skill, intelligence, and creativity of these professionals. And sometimes they raise questions that I think are worth sharing with everyone because they too might've heard the ...
    Posted to Kevin Kline (Weblog) by KKline on September 23, 2008
  • More Pages Reported Than Actually Exist in the Table

    MVP Hugo Kornelius once reported that he encountered a situation in which it was possible to perform a table scan on more pages than actually existed in the heap table.  Hugo deduced that this was due to a phenomenon called “forwarding pointers”.    Why in the world would this ever happen?  Real Paul Randall’s excellent blog ...
    Posted to Kevin Kline (Weblog) by KKline on October 26, 2007
  • Changing PerfMon Counters on SQL2000 vs SQL2005

    You might have noticed, if you’re a heavy user of PerfMon, that some counters are exhibiting alterations in behavior between SQL Server 2000 and SQL Server 2005.  For example, I’ve long used the “Transactions/sec” counter to get an idea of how much work a SQL Server is accomplishing.  Now, in SQL Server 2005, certain internal system ...
    Posted to Kevin Kline (Weblog) by KKline on October 15, 2007
  • Beware of computed columns

    If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005. One of the changes in SQL Server 2005 was to evaluate expressions in queries to match computed column expressions and identify redundant expressions, in order to prevent run-time errors in queries that have unsafe expressions. This is documented ...
    Posted to Kevin Kline (Weblog) by KKline on October 11, 2007
  • Useful Index Information Scripts for SQL Server 2005

    Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health.  The queries are not rocket science, but they are long and rely on DMVs that you may not have learned about yet.  They also provide useful and ...
    Posted to Kevin Kline (Weblog) by KKline on August 31, 2007
Privacy Statement