Would You Like To Play A Game?
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
776 reads
Another Lunch Story
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
587 reads
Iron Chef Returns to SQL Saturday Tampa - Jan 15 2011
SQL Stadium will be crowded with anticipation very soon in Tampa. Come watch as Adam Jorgensen takes on a challenger...
2010-12-20
881 reads
The iPad/SQL Monitor Results
I ended up with 131 posts (1 late hit, sorry), not counting any duplicates with Brent or Steve. It was...
2010-12-20
888 reads
Turn Off AutoShrink!
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said...
2010-12-20
616 reads
And the winners are….. (iPads for Christmas contest)
Congratulations to the following winners of our iPads for Christmas contest. It was a hard choice, but I ended up...
2010-12-20
1,303 reads
SQL Server Storage Internals Part 3 - Architecture of Heaps
In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...
2010-12-19
5,598 reads
SQL Server 2005 Service Pack 4 RTM
Service Pack 4
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL...
2010-12-18
843 reads
SQL Saturday 62 – Tampa FL – January 15th 2011
On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous...
2010-12-18
1,196 reads
Pragmatic Works Seeking Employment Candidates
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
428 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
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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