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

Stored procedure with table parameter

You plan to create a stored procedure that uses a table parameter as an input parameter. The table value parameter may hold between 1 and...

Index seek operation -- Nonclustered index

You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query...

Enable the database query store

You have a Microsoft Azure SQL Database named MyDb that uses server version V12. You plan to use Query Performance Insight to...

Indexes to avoid table scans

The Account table was created by using the following Transact-SQL statement: There are more than 1 billion records in the Account table....

A stored procedure to insert data

You are creating a stored procedure which will insert data into the table shown in the Database schema exhibit. You need to insert a new...

Optimizing a SQL query

You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the following issues: ✑ At each...

SQL- Stored procedure: Skip first two INSERT statements

I encounter an interesting question as follows: You have a stored procedure that needs to run three INSERT statements, the first two of...

Case study -- About deadlock

Background - You have a database named HR1 that includes a table named Employee. You have several read-only, historical reports that...

Schema permissions

A database administrator needs to perform specific actions for objects in the database. You need to ensure the administrator can perform...

Schema Design

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

1 2

Topic

aboutME