THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Performance   (RSS)
Showing page 16 of 16 (160 total posts)
  • Configuration Settings in the Recent TPC-H Benchmark

        One of the first places most people tend to think about when considering boosting SQL Server performance are the settings of SP_CONFIGURE.   Yet, when you examine the details of the recent TPC-H benchmark by HP and Microsoft, you’ll see that there really weren’t a very large number of changes to what are typically default ...
    Posted to Kevin Kline (Weblog) by KKline on June 21, 2007
  • Startup Switches used in the Recent TPC-H Benchmark

    Some people take a rather cynical approach to benchmarking by considering them to be inaccurate representations of what the database platform and hardware can do.  They’re cynical because the benchmarkers take every opportunity to give their system every advantage they can.  They view it as a sort of cheating since most real-world ...
    Posted to Kevin Kline (Weblog) by KKline on June 20, 2007
  • Instant Revelations from the Recent TPC-H Benchmarks

    One of the first things you notice about the recently released TPC-H benchmark from HP and Microsoft is that it’s big, REALLY big.  It weighs in at over 500 pages and, since it’s the full disclosure document, contains every minute detail about the benchmarked system and environment you can imagine.  For example, every hard disk in the ...
    Posted to Kevin Kline (Weblog) by KKline on June 19, 2007
  • Multiple-Valued Parameters

    So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited list of values and I knew I could use XML to do the same thing, yet I had never compared the two ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on February 12, 2007
  • Webcasts on-line

    As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...
    Posted to Kevin Kline (Weblog) by KKline on February 8, 2007
  • Speaking in Tel Aviv

    I recently had the pleasure of presenting to a packed house in Tel Aviv (described in  Warning: The website is in Hebrew.  The weather was a gorgeous 70-something and sunny.  Ahhh - the Mediterranean climate of Israel is especially nice to visit in midwinter when it's 20 degrees ...
    Posted to Kevin Kline (Weblog) by KKline on February 4, 2007
  • Surviving the Data Avalanche Webcast Available

    I hosted a vendor roundtable to a packed house at the PASS 2006 Community Summity.  The topic of the roundtable was ''Surviving the Data Avalanche'' and was a free form discussion about topics related to the enormous upswing we're seeing throughout the SQL Server community in terms of data growth and retention. Although the roundtable was ...
    Posted to Kevin Kline (Weblog) by KKline on January 10, 2007
  • A Transaction Log "Ballast" File

    I've done a lot of sessions and articles about performance tuning your SQL Server environment over the years.  A common question that comes up is where and how to place the log files of a SQL Server database.  Of course, ideally, you'd place the transaction logs on their own mirrored pair of disks.  However, the follow-up question ...
    Posted to Kevin Kline (Weblog) by KKline on January 8, 2007
  • Medians, Actual Query Cost, and Statistics

    I was going to comment on Adam's post ''Medians, ROW_NUMBERs, and performance'' (which was a follow-up to Aaron's post ''Take the high road to middle ground'') and I realized that I needed to show some code and alas, comments are not so nice about formatting code, so I am posting a follow-up post... At the PASS Summit back in November, ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on December 20, 2006
  • Consuming Data from the PerfMon Counters

    SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code regardless of knowing if any processes were consuming those ...
    Posted to Kevin Kline (Weblog) by KKline on December 15, 2006
Privacy Statement