Let’s talk about maintenance of system databases in MS SQL Server. There are a few differences from user databases.At first let`s remember what system databases we have and what do they stay for.Master – this database keeps all system-level information of SQL Server instance.Model – this databases is used as a template for all new databases created in SQL Server. Changing of the size, sorting options, recovery model or any other parameters of model database will lead to having the same values of those parameters in all databases created after you change model..

I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought to be the author of. Although RAM is constantly becoming cheaper, still its capacity is always not enough for database server. SQL Server features intelligent caching of frequently requested data, but the data size often exceeds the available amount of memory, which sometimes is difficult to expand. One of the interesting options appeared in SQL Server 2014 is Buffer Pool Extension, which enables cache of data pages on a state solid drive (SSD) in case the RAM is not enough. In this article I present a thorough overview of this technology using SQL Server 2014 CTP1.