top of page
Topic
Recent Posts
Archive
Tags
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...
Service Editions and Tiers
Microsoft uses editions for SQL Server and service tiers for Azure SQL Database to provide combinations of product features, performance,...
bottom of page