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 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
I am pleased to announce that I will be presenting at SQL Saturday #855 in Albany, NY on July 20, 2019. Join me at 2 PM in room LC05...
2019-07-08
10 reads
Hello, data eaters! Today, coming back from my friend by car, I was browsing a few posts on my cell (calmly – my wife was driving). At some point,...
2019-07-07
18 reads
Why do I take pictures of screens at conferences? Let me count them up for you! Read on...
2019-07-05
104 reads
It was a long weekend of travel for me not too long ago, starting at 4:30am on Friday and ending at 7:30pm Sunday night. This was for SQL Saturday...
2019-07-05
30 reads
It is always a dark art trying to suss out why he/she is an MVP? Do they deserve it? What does it take? Why can’t I get it? The...
2019-07-05
26 reads
Here are three scenarios, if you work with SQL Server either as a provider of database environments (DBA) or a consumer of database environments for your application (developer) then...
2019-07-05
8 reads
Here are three scenarios, if you work with SQL Server either as a provider of database environments (DBA) or a consumer of database environments for your application (developer) then...
2019-07-05
17 reads
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-05
27 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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