Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
9 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
21 reads
Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...
2019-07-23
211 reads
Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...
2019-07-23 (first published: 2019-07-09)
813 reads
In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...
2019-07-23 (first published: 2019-07-08)
723 reads
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
302 reads
I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...
2019-07-22 (first published: 2019-07-08)
2,791 reads
2019-07-22
21 reads
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
24 reads
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
971 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers