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

No tags yet.

In honor of Lothar Collatz

In 1937, a German mathematician named Lothar Collatz formulated an intriguing hypothesis (it still remains unproven) which can be...

sqrt() and int()

sqrt() function is an inbuilt function in Python programming language that returns the square root of any number. Syntax: math.sqrt(x)...

For loops

Official definition: https://wiki.python.org/moin/ForLoop Picture source: https://www.python-course.eu/python3_loops.php for loops are...

break and continue

break - exits the loop immediately, and unconditionally ends the loop's operation; the program begins to execute the nearest instruction...

sleep()

The sleep() function suspends (waits) execution of the current thread for a given number of seconds. Python has a module named time which...

while i and for i in range ()

While Loop is used to repeat a block of code. Instead of running the code block once, It executes the code block multiple times until a...

Multi-line printing

You can use triple quotes to print strings on multiple lines in order to make text easier to read, or create a special text-based design....

Inner Join (vs Inline TVF)

Let’s consider a query that combines data from multiple tables to produce the query plan. The Hash Match (Inner Join) operator combines...

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

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

Topic

aboutME