SQL Saturday Advice - Extra Food
No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday...
2010-10-21
685 reads
How Often Do You Run CHECKDB Against Your Databases?
I recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of...
2010-10-21
3,078 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,438 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
748 reads
SQLRally Pre Con Update
The call for Pre Con speakers for the 2011 PASS SQLRally closed last Friday (Oct. 15) and I want to...
2010-10-20
390 reads
New Cumulative Updates for SQL Server 2005 and SQL Server 2008 R2
Late Monday night (October 18, 2010), Microsoft released the latest Cumulative Updates for SQL Server 2005 and for SQL Server...
2010-10-20
930 reads
Minutes of the September 2010 PASS Board Meeting Posted
Please take a few minutes to review the September 2010 minutes (login required). We just had our October meeting on...
2010-10-20
663 reads
SQLSaturday #49–The Poster!
Over the past few months I’ve been thinking that we don’t do enough to celebrate the people and the effort...
2010-10-20
598 reads
Boulder SQL Server User’s Group - Common SQL Server Mistakes
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
988 reads
SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might...
2010-10-20
586 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