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 » Testing » performance   (RSS)
  • Why generalizations are dangerous

    A couple of years ago, John Sansom wrote a blog post comparing the performance of two different ways to get the maximum value from a column: MAX() and TOP (1). http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/ In the conclusion, he states:  When a clustered index is present on the table & ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 15, 2011
  • SQL Server Backup Simulator

    The SQL Server support team just announced the release of a backup simulator. Many 3rd party utilities that do backup like IBM Tivoli, Symantec BackupExec, Quest Litespeed, Redgate SQL Backup etc. use the sqlvdi.dll to communicate to SQL Server and this allows you to simulate that activity. So if you want to test how your system reacts or more ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 28, 2010
  • 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
Privacy Statement