Daily Denali Delight – Day 2
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
760 reads
Awesome Software/Training Deal!
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
468 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
778 reads
Building an algorithm
When I was in college, and even high school, all of my computer science classes required me to build algorithms....
2011-04-20
1,538 reads
Fail-Win Balance
It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for...
2011-04-20
527 reads
Daily Denali Delight – Day 1
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released (is this still unconfirmed?) you...
2011-04-20
916 reads
CodeName for the next generation of SQL Server??
Ever since the first version of SQL Server (1988??), Microsoft has found some interesting codenames for their releases
1993 – SQL Server 4.211995...
2011-04-20
793 reads
Powershell Day 20
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
429 reads
Adding Data Files To A Mirrored Database
This is my first post! I don't really expect anyone to find this blog.
So I have a pretty big...
2011-04-20
3,801 reads
SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
724 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...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
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