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
428 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
Evaluating my SQL Connection Scores
This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...
2011-04-20
1,487 reads
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
546 reads
Tech events in Kosova 2011
Hello everybody, some tech events are announced to be held in Kosova soon …
Soon other details will be posted and...
2011-04-19
529 reads
The Mentoring Experiment
Andy Warren (LinkedIn | Blog | @sqlandy) and I had an idea for a way to give back to the community and...
2011-04-19
1,128 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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