Architecture And Editions of Sql Server

Authors

  • Peddyreddy. Swathi  SQL Server DBA/Salesforce Admin, Buffini and Company, Carlsbad, CA, USA

Keywords:

Sql Server, Databases, Architecture

Abstract

The SQL Server Database Engine divides each physical log file internally into a number of virtual log files. Virtual log files have no fixed size, and there is no fixed number of virtual log files for a physical log file. We recommend that you assign log files a size value close to the final size required, and also have a relatively large growth_increment value. SQL Server uses a write-ahead log (WAL), which guarantees that no data modifications are written to disk before the associated log record is written to disk. This maintains the ACID properties for a transaction. This paper provides the information about architecture and editions of SQL SERVER.

References

  1. Blaha, Michael R. A Manager’s Guide to Database Technology. Upper Saddle River, NJ: Prentice Hall (2001). ISBN 0-13-030418-2.
  2. Connolly, Thomas, and Carolyn Begg. Database Systems: A Practical Approach to Design, Implementation, and Management. 4th ed. Har- low, England: Addison-Wesley (2004). ISBN 978-0-321-29401-2.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2018-07-30

Issue

Volume 2, Issue 3, May-June-2017

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Peddyreddy. Swathi, " Architecture And Editions of Sql Server" International Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 3, pp.967-973, May-June-2017.