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 » Tips » Internals   (RSS)
Showing page 2 of 2 (14 total posts)
  • 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
  • The Perils of Hyperthreading for SQL Server

    Just a quick note to send a big Thank You to Christoph Stotz of Frankfurt, Germany for his hospitality on Sunday.  Thank you, Christoph!  Slava Oks has a rather well-known blog entry about how hyperthreading can negatively impact the performance of a SQL Server 2000 instance: ...
    Posted to Kevin Kline (Weblog) by KKline on August 18, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement