MS SQL Admin

Browse by Tags

• Database Tuning Advisor
• DTA
• Profiler
• SET STATISTICS IO
• SET STATISTICS TIME
• Statistics
• Variables

• How to Tune a Database Using the Database Tuning Advisor (DTA)

  The Database Engine Tuning Advisor (DTA) is a new tool in SQL Server 2005 that enables you to tune databases and improve the performances of your queries. DTA examines how queries are processed in the databases you specify and then it recommends how you... Posted Apr 05 2008, 09:51 AM by Eric Vaillancourt with | with 2 comment(s) Filed under: Performance, Tuning, Statistics, Database Tuning Advisor, Profiler, DTA

• Avoid using local variables in your Select statements

  People are always surprised when I tell that their queries will run slower when they use local variables in their queries. Let me explain: If you use a local variable in a query predicate instead of a parameter or literal, the optimizer resorts to a guesstimate... Posted Mar 29 2008, 05:36 PM by Eric Vaillancourt with | with 1 comment(s) Filed under: Performance, Tuning, Statistics, Variables

• Understanding SET STATISTICS IO and SET STATISTICS TIME

  Today, I want to talk about two commands that are often overlooked. SET STATISTICS IO and SET STATISTICS TIME these two commands are very useful when comes time to tune a query. Tuning a query seems simple enough. In essence, we want our searches to run... Posted Mar 23 2008, 01:15 PM by Eric Vaillancourt with | with 2 comment(s) Filed under: SET STATISTICS IO, Performance, SET STATISTICS TIME, Tuning