top of page
Topic
Recent Posts
Archive
Tags
Activity Monitor
Overview The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic...
Data change recording
SQL 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 Views
Indexed View Creating a unique clustered index on a view improves query performance because the view is stored in the database in the...
Database Snapshot
When we create the database snapshot in the live operational database, it takes a database point in time static view and Rollback all...
Baseline performance
There are four tools that we can use to check performance metrics for the operating system and SQL Server: Dynamic management objects...
Common Table Expressions (CTEs)
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...
#temp table v.s. @table
Database is all about tables. Apart from normal tables, there are two kinds of tables: Temporary tables (#temp table) and table variables...
The backstage architecture
Many recent sessions emphasize the role of Query Store. Today, I attended another session regarding Query Store. The topic of the session...
With Check Option
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...
SQL Server Profiler
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...
bottom of page