What’s New in SQL Server “Denali” CTP1
Denali. No, not that one...
How many of you have heard that the Community Technology Preview (CTP1) for the next version...
2010-11-18
739 reads
I am a Risk Taker
Somewhat of a strange title, but it’s been an interesting journey to understand that I do take risks and to...
2010-11-18
564 reads
Recompiles
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...
2010-11-18
2,164 reads
Reason for Early Termination of Statement
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,054 reads
Part of the Election Review Committee...
... and I'm wary, but not weary. I'm not weary because I'm looking forward to trying to help. I'm not weary...
2010-11-18
1,143 reads
XQuery for the Non-Expert – Terminology
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...
2010-11-18
818 reads
SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
Only two days left until our super SQLSaturday#59 event. Hope all is well...
2010-11-18
796 reads
Announcing the SQLDoctor
Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.
The concept of the SQLDoctor...
2010-11-17
570 reads
Un-SQL Friday 001: Branding
In the spirit of T-SQL Tuesday, I hereby declare this Friday Un-SQL Friday. While T-SQL Tuesday is “…the SQL Server...
2010-11-17
611 reads
PASS Summit Report 3: Women in Technology Rock!
Last year I was honored to be a member of the Women in Technology (WIT) Panel at the PASS Summit....
2010-11-17
1,199 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Question of the Day
The Range of Customers
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