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.

Table UDF

You have a database that contains the following tables: BlogCategory, BlogEntry, ProductReview, Product, and SalesPerson. The tables were...

Partitioned and Indexed views

You have a Microsoft SQL Server database named DB1 that contains the following tables: OR OR There are no foreign key relationships...

Fixing the stored procedure

You have a memory-optimized table named Customer. The table is accessed by a stored procedure named ManageCustomer. The database was...

Schema permissions using the principle of least privilege

You need to ensure the administrator can perform the tasks using the principle of least privilege. Which schema permissions should you...

Table-valued parameters

You manage a database with tables named Invoice and InvoiceDetails. Each invoice may have multiple records. Users update the...

@@TRANCOUNT (T-SQL)

Many good resources for @@TRANCOUNT: https://docs.microsoft.com/en-us/sql/t-sql/functions/trancount-transact-sql?view=sql-server-ver15...

Enabling the collection of Info. for natively compiled stored procedures

The goal of using memory-optimized tables is to execute processes as quickly as possible. Consequently, you could be surprised that some...

Capturing natively complied stored procedure by Extended Events

An Extended Events session is the equivalent of a trace. When you create a session, you add an event and actions to fire with that event,...

Developing a stored procedure @Trancount

You are developing a stored procedure with the following requirements: ✑ Accepts an integer as input and inserts the value into a table....

Create Index Based on Query Plan

You use Query Store to optimize a query in a database. The query has two execution plans: ✑ Plan 2 is shown in the Plan 2 Execution...

3 4

Topic

aboutME