Optimizing Queries In Sql Server 2008
Nicolae Mercioiu and
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, pages 103-108
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)
References: Add references at CitEc
Citations Track citations by RSS feed
Downloads: (external link)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
Persistent link: http://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 Logica Banica
More articles in Scientific Bulletin - Economic Sciences from University of Pitesti Contact information at EDIRC.
Series data maintained by Logica Banica ().