Improving SQL Server Perform

Improving SQL Server Perform

With the development of client server technology and multilayer architectures the systems ef-ficiency issue has been increasingly discussed. Lacking knowledge in optimization methods and tools offered by DBMS's, database administrators and developers of applications based on Microsoft technolog...

Full description

Bibliographic Details
Main Authors: Nicolae MERCIOIU, Victor VLADUCU
Format: Article
Language:English
Published: Inforec Association 2010-01-01
Series:Informatică economică
Subjects:
Query
Optimization
SQL Server
Online Access:http://revistaie.ase.ro/content/54/06%20Mercioiu,%20Vladucu.pdf
id doaj-a332f3f817a94dc9bb9a3c56aaa0ee3e
record_format Article
spelling doaj-a332f3f817a94dc9bb9a3c56aaa0ee3e2020-11-24T23:33:42ZengInforec AssociationInformatică economică1453-13051842-80882010-01-011425560Improving SQL Server PerformNicolae MERCIOIUVictor VLADUCUWith the development of client server technology and multilayer architectures the systems ef-ficiency issue has been increasingly discussed. Lacking knowledge in optimization methods and tools offered by DBMS's, database administrators and developers of applications based on Microsoft technologies cannot optimally design and service performing systems. In this article we review the objectives that should be considered (in order) to improve performance of SQL Server instances and we describe the techniques used to optimize queries. Also, we explain and illustrate the new optimization features offered by SQL Server 2008. http://revistaie.ase.ro/content/54/06%20Mercioiu,%20Vladucu.pdfQueryOptimizationSQL Server
collection DOAJ
language English
format Article
sources DOAJ
author Nicolae MERCIOIU
Victor VLADUCU
spellingShingle Nicolae MERCIOIU
Victor VLADUCU
Improving SQL Server Perform
Informatică economică
Query
Optimization
SQL Server
author_facet Nicolae MERCIOIU
Victor VLADUCU
author_sort Nicolae MERCIOIU
title Improving SQL Server Perform
title_short Improving SQL Server Perform
title_full Improving SQL Server Perform
title_fullStr Improving SQL Server Perform
title_full_unstemmed Improving SQL Server Perform
title_sort improving sql server perform
publisher Inforec Association
series Informatică economică
issn 1453-1305
1842-8088
publishDate 2010-01-01
description With the development of client server technology and multilayer architectures the systems ef-ficiency issue has been increasingly discussed. Lacking knowledge in optimization methods and tools offered by DBMS's, database administrators and developers of applications based on Microsoft technologies cannot optimally design and service performing systems. In this article we review the objectives that should be considered (in order) to improve performance of SQL Server instances and we describe the techniques used to optimize queries. Also, we explain and illustrate the new optimization features offered by SQL Server 2008.
topic Query
Optimization
SQL Server
url http://revistaie.ase.ro/content/54/06%20Mercioiu,%20Vladucu.pdf
work_keys_str_mv AT nicolaemercioiu improvingsqlserverperform
AT victorvladucu improvingsqlserverperform
_version_ 1725531200107315200

Similar Items