A Trio of Table Variables
So, it’s the second Tuesday of the month again, and it’s time for T-SQL Tuesday again. This month it’s hosted...
2010-10-12
1,271 reads
SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,962 reads
Speaking at South Florida SQL Server User Group
I will be speaking at the South Florida SQL Server User Group on October 13 via Live Meeting. My topic...
2010-10-12
445 reads
SQLSaturday#59 - Interview with Robert Pearl (1st in series)
SQLSaturday#59 - Interview with Robert Pearl (1st in series) - Say what?
As we get the countdown under way, I caught up...
2010-10-12
1,220 reads
Google Wind
I’m not sure Google is a better company than Microsoft or some of the other extremely large companies that get...
2010-10-12
818 reads
Press Release: SQLSaturday#59 Speaker Session Schedule Announced...
Source Event Home Page: http://www.sqlsaturday.com/59/eventhome.aspx
Written & Distributed by: Robert Pearl
You may have heard that we’re planning an event in NYC, called...
2010-10-12
943 reads
Review: NPR Baseball Driveway Moments
NPR Baseball Driveway Moments ($15 @ Amazon) is an audio book I got from the local library to listen to on...
2010-10-12
389 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
5 reads
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,430 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-12
1,263 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