A SQL Server Hardware Nugget A Day – Day 10
Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By...
2011-04-10
368 reads
SQLBits 8 – That’s a Wrap
This weekend saw the 8th SQLBits conference take place amidst glorious British sunshine by the sea in Brighton.
For those unable...
2011-04-10
890 reads
Powershell Day 10
Day 10 Working with Directory and Registry As you know, Powershell works with command prompt, and you know it works...
2011-04-10
306 reads
So, what’s this heap thing?
G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...
2011-04-10
2,410 reads
Shrinking the log file script for SQL server database
AdvertisementsShrinking the log file script for SQL server database
This script mainly for a DBA’s, because most of the time...
2011-04-10
2,030 reads
A SQL Server Hardware Nugget A Day – Day 9
For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for...
2011-04-10
596 reads
Powershell Day 9
Day 9 Process and Service Service: For Powershell we can also work with services. You can see which all services...
2011-04-09
376 reads
Hostettler & the Bottleneckers
A bit of fun !
A long long time ago before the dawn of 2010, somewhere to the South of the...
2011-04-08
617 reads
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,023 reads
A SQL Server Hardware Nugget A Day – Day 8
For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for...
2011-04-08
426 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