Isolation levels
The goal of isolation levels is to ensure that queries return complete and consistent results while other concurrent processes are...
top of page
Topic
Recent Posts
Archive
Tags
No tags yet.
Bulk Load
Bulk Load Into a Clustered Columnstore Different from bulk loading data into a rowstore table, you can load bulk amounts of data into a...
Agent job
SQL Server updates statistics automatically by default, but you can disable the automatic update and instead rely on a maintenance plan...
Worker threads
Worker (worker thread) – This is the logical SQL Server representation of a thread (think of it as a wrapper on top of the OS thread). It...
Collection of execution statistics for natively compiled stored procedures
Use the system stored procedures sys.sp_xtp_control_proc_exec_stats and sys.sp_xtp_control_query_exec_stats to enable or disable the...
Elastic Scale -- Sharding
By using Elastic Scale for Azure SQL Database, you can manage your data in separate shards for which resource requirements can...
Always on Availability groups
The ability to use both columnstore and nonclustered indexes in memory-optimized tables makes it much easier to support both OLTP and...
Trigger
Hi Zoran, I hope you are doing well. Would you mind having a look at the following issue? There are two tables: Order Table and...
Automatic statistics updates
Statistics are generated when you add an index to a table that contains data or when you run the UPDATE STATISTICS command. In most...
Cross-container transactions
A transaction is called a cross-container transaction if it: Accesses a memory-optimized table from interpreted Transact-SQL; or Executes...
bottom of page