Improving SQL Server Performance

Αποθηκεύτηκε σε:

Λεπτομέρειες βιβλιογραφικής εγγραφής
Εκδόθηκε σε:	Informatica Economica vol. 14, no. 2 (2010), p. 55-60
Κύριος συγγραφέας:	Mercioiu, Nicolae
Άλλοι συγγραφείς:	Vladucu, Victor
Έκδοση:	INFOREC Association
Θέματα:	Studies Structured Query Language-SQL Optimization Client server computing Queries Values Servers Optimization techniques
Διαθέσιμο Online:	Citation/Abstract Full Text Full Text - PDF
Ετικέτες:	Προσθήκη ετικέτας Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!

Περιγραφή
Περίληψη:	With the development of client server technology and multilayer architectures the systems efficiency 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. [PUBLICATION ABSTRACT]
ISSN:	1453-1305 1842-8088
Πηγή:	ABI/INFORM Global