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 » Query Tuning » Performance   (RSS)
Showing page 2 of 2 (15 total posts)
  • Medians, ROW_NUMBERs, and performance

    A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even better way to attack the problem in Joe Celko's Analytics and OLAP in SQL.Rather than using a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 18, 2006
  • Announcing SQLQueryStress: A simple query load tool

    On October 20, 2004 -- two years ago -- I announced that I was considering writing my own query load testing tool.Clearly, my follow through on this promise has been incredibly delayed.  But all is not lost, and I'm happy to report that I am true to my word.  As of today, beta-1 of my new SQLQueryStress tool is available for ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 21, 2006
  • Exploring the secrets of intermediate materialization

    When working with SQL Server 2000, I used to have this little trick I'd pull out after exhausting all other ideas for tuning a query.  And I thought that my little trick was dead in SQL Server 2005, but thanks to fellow SQL Server MVP Rob Farley, I am officially reviving my trick from the dead here and now, in this blog post.... But first, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 3, 2006
  • Scalar functions, inlining, and performance: An entertaining title for a boring post

    Scalar.  Function.Wow.Could any other combination of words evoke the same feeling of encapsulation, information hiding, and simplification of client code?  After years spent developing software in the procedural and OO worlds, it can be difficult--perhaps, even impossible--to migrate over to working with SQL Server and not consider how ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 3, 2006
  • Paging in SQL Server 2005

    I keep seeing questions on newsgroups about paging in stored procedures, and whether there will be a better way in SQL Server 2005. However, aside from a few answers in newsgroups, I haven't seen any content on how to do it. So I'd like to spend a few minutes and share with you the new features that will make paging stored procedures ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement