PASS Summit 2010 Survey Results
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
800 reads
Filling in Data Potholes with Recursive CTEs
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,149 reads
Spreading the DBA Gospel (from Old English, god spell "good news")
There are times when I wonder why I get so few comments on this blog, however there are assumptions I...
2010-12-23
762 reads
Updated SQLRally Flyer
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
718 reads
Lunch Story #3–No Free Sandwiches
This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...
2010-12-23
561 reads
How To Choose A Topic For Speaking
“The human brain starts working the moment you are born and never stops until you stand up to speak in...
2010-12-23
1,187 reads
Strange issue while using IDENTITY values in INSTEAD OF triggers
Found an interesting issue last week....it goes like this:
If you are using INSTEAD OF triggers on views (in SQL 2005)...
2010-12-23
797 reads
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I...
2010-12-23
1,370 reads
Intel Sandy Bridge Processor Machines Coming Soon!
If you are in the market to buy or build a new laptop or desktop computer, you might want to...
2010-12-22
724 reads
SQL Server 2005 SP3 Cumulative Update 13 Released
Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...
2010-12-22
860 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