Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
2019-07-30
200 reads
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
9 reads
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
11 reads
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
14 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-07-30
29 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-07-30
70 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-07-30
9 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-08-13 (first published: 2019-07-30)
3,255 reads
Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...
2019-08-12 (first published: 2019-07-30)
700 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
Last week...
2019-07-30
13 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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