Fast-Track Data Warehouse for Windows Azure
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data...
2013-11-05
1,443 reads
Blog Posts
Is There Interest in SQL Server Security Pre-Cons?
I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this...
2013-11-05 (first published: 2013-10-30)
2,728 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2013-11-05
6 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2013-11-05
785 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic | blog) back...
2013-11-05
9 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic | blog) back...
2013-11-05
13 reads
T-SQL Tuesday #48– Cloud Atlas
Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that...
2013-11-05
687 reads
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this
particular file there are around 2 million records. The file needs to be
split into...
2013-11-05
16 reads
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this
particular file there are around 2 million records. The file needs to be
split into...
2013-11-05
15 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.5: The Predict Method
By Steve Bolton
…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of...
2013-11-04 (first published: 2013-10-30)
2,786 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