#system databases

Introduction Have you ever wondered if the collation of your user databases and system databases in SQL Server could impact performance? As a database administrator, I’ve grappled with this question myself. In this article, I’ll share what I’ve learned about collations, how they affect queries, and whether it’s a good idea to change system database collations to match user databases. By the end,…

Understanding SQL Server Databases

To manage a database server, you need to understand the types of databases available and the location of those databases. There are two types of databases available in SQL Server:

System Databases

User Databases

System Databases

The system databases are default databases that are created when SQL Server is installed. These databases are used for various operational and management activities for…

Chapter 4: Special databases

In this chapter Kalen Delaney and Benjamin Nevarez tell us about system databases, tempdb and contained databases.

(more…)

Understanding SQL Server Databases

To manage a database server, you need to understand the types of databases available and the location of those databases. There are two types of databases available in SQL Server:

System Databases

User Databases

System Databases

The system databases are default databases that are created when SQL Server is installed. These databases are used for various operational and management activities for…