Free Online SQL Server Training for the Week of November 3, 2013
I'm trying to re-establish this running guide to free online training for the following week. If you're a training provider...
2013-10-31
3,365 reads
Blog Posts
Happy Halloween! A TALE OF THE SCARY DBA! - Reblog
Today, October 31, 2013 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and...
2013-10-31
1,995 reads
One day in the office
I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling...
2013-10-31
1,200 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,277 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
8 reads
SQL Server Data Tools for SQL Server 2014 CTP2 now available
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL...
2013-10-31
1,583 reads
SSIS Pivot on bad data
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...
2013-10-31 (first published: 2013-10-28)
1,798 reads
Tales from the Query Processor: II
Hello Dear Reader! Today is Halloween, October 31st. My Daughter turns a big 15 today! Happy Birthday Ches!!!!!
To celebrate two...
2013-10-31
1,385 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to...
2013-10-31
1,243 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to data. Sometimes it is in the capacity of a...
2013-10-31
7 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