期刊名称：Buletin ştiinţific: Universitatea din Piteşti. Seria Ştiinţe Economice
印刷版ISSN：1583-1809
电子版ISSN：2344-4908
出版年度：2010
卷号：9
页码：103-108
语种：English
出版社：Publishing house of University of Pitesti, Romania
摘要：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.
