2010 Recap
As a part of a recap on the year that was 2010, I should start with a recap of my goals. For that review I had to go back...
2010-12-28
6 reads
2010-12-28
682 reads
T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,725 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
61 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be...
2010-12-28
1,472 reads
Wrapping Up 2010
Goal Setting
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to...
2010-12-28
905 reads
RTFM365, Week 3
Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my...
2010-12-28
770 reads
Can You Dig It? – StmtCursor and StmtReceive Elements
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2010-12-28
1,217 reads
SSAS Understanding Multiple Security Roles
In a previous article I showed how you can create dynamic security in SSAS.This is a great way to make...
2010-12-28
3,200 reads
SSMS Tools Pack (free), supports SQL Sever Denali CTP1
Free tools are very welcome to the community, while some of the creators of these kind of the tools are...
2010-12-28
1,537 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