Topic

Recent Posts

Bitwise operators

In honor of Lothar Collatz

sqrt() and int()

For loops

String Methods

break and continue

sleep()

Assignment Operators

while i and for i in range ()

Multi-line printing

Compact while()

int()

float() and round()

if-elif-else instructions

Time evaluation

end=, sep=, +, *, and /

Assignment (Shortcut) operators

Binary <==> Decimal Conversion

Data scientists vs analysts

Performance, error and warning events

Inner Join (vs Inline TVF)

Query performance

exec_query_stats

REORGANIZE vs REBUILD

Data Collector vs Activity Monitor

Database recovery

Version Store

Activity Monitor

Data change recording

Indexed v.s. Partitioned Views

Database Snapshot

Baseline performance

Common Table Expressions (CTEs)

#temp table v.s. @table

The backstage architecture

With Check Option

SQL Server Profiler

Memory-Optimized Tables -- Non-durable v.s. variable

Azure Portal

Service Editions and Tiers

Extreme Transaction Processing (XTP)

Lock Events Category

GRANT Object Permissions

Identify missing indexes

Query Store properties

SQL Syntax

Resource Pool

Stored procedure with OUTPUT and READONLY

Statistics updates

Extended Event

Tags

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...

estimated v.s. actual plan

An essential tool for designing indexes is the query plan. Use the graphical versions from the UI, or one of the SET SHOWPLAN commands to...

Topic

aboutME