Optimizing Queries In Sql Server 2008

Ion Lungu, Nicolae Mercioiu and Victor Vladucu
Additional contact information
Ion Lungu: Academy of Economic Studies, Bucharest, Romania
Nicolae Mercioiu: Prosecutor's Office attached to the High Court of Cassation and Justice
Victor Vladucu: 3Prosecutor's Office attached to Vâlcea Court

Scientific Bulletin - Economic Sciences, 2010, issue 9, 103-108

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

Keywords: Query; SQL Server 2008; Optimization (search for similar items in EconPapers)
JEL-codes: C88 D80 (search for similar items in EconPapers)
Date: 2010
References: Add references at CitEc
Citations:

Downloads: (external link)
http://economic.upit.ro/repec/pdf/I2.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:pts:journl:y:2010:i:1:p:103-108

Access Statistics for this article

Scientific Bulletin - Economic Sciences is currently edited by Alina Hagiu

More articles in Scientific Bulletin - Economic Sciences from University of Pitesti Contact information at EDIRC.
Bibliographic data for series maintained by Alina Hagiu ().