Buletin ştiinţific: Universitatea din Piteşti. Seria Ştiinţe Economice (May 2010)

Optimizing queries in SQL Server 2008

  • Ion LUNGU,
  • Nicolae MERCIOIU,
  • Victor VLADUCU

Journal volume & issue
Vol. 9, no. 1
pp. 104 – 108

Abstract

Read online

Starting from the need to develop efficient IT systems, we intend to review theoptimization methods and tools that can be used by SQL Server database administratorsand developers of applications based on Microsoft technology, focusing on the latestversion of the proprietary DBMS, SQL Server 2008. We’ll reflect on the objectives tobe considered in improving the performance of SQL Server instances, we will tackle themostly used techniques for analyzing and optimizing queries and we will describe the“Optimize for ad hoc workloads”, “Plan Freezing” and “Optimize for unknown" newoptions, accompanied by relevant code examples.

Keywords