Ben Nevis Nov 2010
Ben Nevis – November 2010
Last major training trek before Kili !!
Was pretty cold up in Scotland………
2011-01-05
400 reads
Rebuilding the W510 - DVD Driver Issues with x64
I backed up my machine, copied a bunch of data to both a thumb drive as well as the second...
2011-01-05
900 reads
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions on the schedule. My answer is a resounding...
2011-01-05
9 reads
31 Days of SSIS – One Variable to Rule Them All (5/31)
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I am writing. Today...
2011-01-05
465 reads
Presenting At SQLSaturday #62 - Tampa
Even though I live in Orlando - just a hop, skip, and jump away from Tampa - I've missed their SQLSaturday for...
2011-01-05
567 reads
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more info here. There is a bit of interesting news...
2011-01-05
6 reads
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more...
2011-01-05
675 reads
Tech Books: Caveat Emptor
These days, we have a myriad of ways to judge whether any given product – like, say, a book on SQL...
2011-01-05
780 reads
Good People Know Good People
I can’t remember where I heard this recently, but it’s been stuck in my head as one of those bits...
2011-01-05
620 reads
Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
603 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