Topic

Overview The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic...

SQL Server 2019 (15.x) provides two features that track changes to data in a database: change data capture and change tracking. These...

Indexed View Creating a unique clustered index on a view improves query performance because the view is stored in the database in the...

When we create the database snapshot in the live operational database, it takes a database point in time static view and Rollback all...

There are four tools that we can use to check performance metrics for the operating system and SQL Server: Dynamic management objects...

if you need to reference/join the same data set multiple times you can do so by defining a CTE. Therefore, it can be a form of code...

Database is all about tables. Apart from normal tables, there are two kinds of tables: Temporary tables (#temp table) and table variables...

Many recent sessions emphasize the role of Query Store. Today, I attended another session regarding Query Store. The topic of the session...

When using a view as an interface like we are doing in this section, one of the things that you generally don’t want to occur is to have...

Of course, deadlocks are not typically going to happen while you watch, so how can you know when and why they occur? You can use either...