Kamil

My name is Kamil Nowinski and I'm the founder & owner of SQLPlayer blog.
I'm Microsoft Data Platform MVP, MCSE. Senior Data Engineer, data geek and friend of Redgate. I speak at user groups and conferences across Europe. Love #SQLfamily and Community around Microsoft Data Platform - that's why my podcast is called "Ask SQL Family" where I talk to well-known and valued specialists in the industry (including Microsoft employees).

Blog Post

Last Week Reading (2019-06-09)

Hello there! Another week, another roundup of Internet interesting stuff. Press Microsoft Business Applications Summit The event is happening now in the Georgia World Congress Center in Atlanta, GA....

2019-06-10

20 reads

Blog Post

Last Weeks Reading (2019-05-26)

It was tremendously extensive week for me (a week ago) when I spent time between two conferences: SQLDay (Wroclaw, Poland) and SQL Saturday #857 (Kiev, Ukraine). I’ve been helping...

2019-05-26

15 reads

Blog Post

Last Week Reading (2019-05-12)

Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...

2019-05-13

19 reads

Blogs

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

A Guatemalan's Guide to Drinking Coffee Properly

By

My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...

Read the latest Blogs

Forums

Partitioning a table with TEXTIMAGE_ON option

By Brandie Tarvin

I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...

OUTER APPLY Fundamentals: Part 2

By Imran2629

Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2

Building Great Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Great Software

Visit the forum

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          1
If I run this query, how many rows are returned?
SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers