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 » Trace » Performance   (RSS)
  • Using Qure Workload Optimizer for SQL Sentry

    Last week at SQL Bits #8 in Brighton, England, SQL Sentry (my employer) announced its partnership with DBSophic, makers of the Qure workload management suite. Qure Workload Optimizer is a tool aimed at analyzing a workload and providing suggestions to improve the overall performance of that workload. These suggestions can range from adding and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 21, 2011
  • Match those types!

    This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the column side - not the literal side of your query. What does that mean? Consider below: WHERE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 28, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement