Activity MonitorOverview The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic...
Data change recordingSQL Server 2019 (15.x) provides two features that track changes to data in a database: change data capture and change tracking. These...
Indexed v.s. Partitioned ViewsIndexed View Creating a unique clustered index on a view improves query performance because the view is stored in the database in the...