-
CASE Expression: Two Important Things
-
INNER JOIN and Matching Rows
-
Isolation Levels Repeatable Read
-
Don't just give someone the answer
-
Don't just give someone the answer
-
Save as and include column headings
-
Syntax Style
-
Azure SQL Database vs. Fabric Database
-
Help the SQL Engine Do Its Job Better
-
Up and Running SQL Server 2025
-
Deadlocks and the Terminator
-
SQL Is a Declarative Language
-
OLTP and OLAP Serve Different Purposes
-
Table Size Influences Deadlock Susceptibility
-
Provide SQL Reader Access with Caution
-
Mistakes Equal Learning
-
Use Equality Versus Inequality
-
Illustrate a Deadlock
-
Writing Is Thinking
-
Should You Skip Repeatable Read
-
Showing Query Windows Side by Side
-
Reading a Technical Book
-
Downsides to SELECT *
-
CASE Is an Expression
-
Balance Between Concurrency and Consistency
-
Start to Learn SQL in a Day
-
Reducing Deadlocks
-
Focus on the Task at Hand
-
Inserts and New Parquet Files
-
Concurrency in a Fabric Warehouse
-
Converting Chained CTEs to Temporary Tables Using ChatGPT
-
Indexes can improve the speed of DELETE statements
-
SQL Server Doesn't Like Filtered Indexes
-
Lots of page reads correlate to slow queries
-
An Index is a Smaller Copy of the Data
-
SQL Server Management Studio 21 is a much better product
-
A Database's Prime Objective is to Capture and Store Data
-
Difference between Read Committed Snapshot and Snapshot