Academic Journals Database
Disseminating quality controlled scientific knowledge

Optimizing queries in SQL Server 2008

Author(s): Ion LUNGU | Nicolae MERCIOIU | Victor VLADUCU

Journal: Scientific Bulletin : Economic Sciences
ISSN 1583-1809

Volume: 9;
Issue: 1;
Start page: 104;
Date: 2010;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: Query

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.

Tango Jona
Tangokurs Rapperswil-Jona

RPA Switzerland

RPA Switzerland

Robotic process automation