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...
top of page
Topic
Recent Posts
Archive
Tags
No tags yet.
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...
Memory-Optimized Tables -- Non-durable v.s. variable
In-Memory OLTP provides the following objects that can be used for memory-optimizing temp tables and table variables: Memory-optimized...
Azure Portal
There are several diagnostic tools available to you for monitoring SQL Database performance. For a quick view of performance metrics, use...
bottom of page