Post Event Notes - SQLSaturday #8
Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and...
2008-10-27
1,330 reads
SQLAndy
After Event Notes on SQLSaturday #8 in Orlando
By any measure the event was a success. We had a solid 275 attendees this year, up about 50 from last...
2008-10-25
1,502 reads
Good Ideas Take Time or How to Brainstorm - Part 2
In Good Ideas Take Time or How to Brainstorm - Part 1 I wrote about how I come up with ideas...
2008-10-23
1,603 reads
Good Ideas Take Time or How to Brainstorm - Part 1
Occasionally I'm asked how I come up with ideas for my blog to maintain the just about one a day...
2008-10-22
686 reads
Water & Cell Phones Don't Mix
Obviously, right?
I managed to knock my Blackberry Curve off the bar and into a bowl of water in the sink....
2008-10-21
621 reads
Todo List Follow Up - The Notepad
Recently I posted about Managing My Todo List and I had a question via email about what notepad I was...
2008-10-20
799 reads
Understanding Microsoft Licenses - A Short Follow Up
I posted Do You Understand Microsoft Licenses about a week ago, and today happened to run across a note about...
2008-10-20
536 reads
Final Preparations for SQLSaturday #8 on October 25th, 2008
I suspect final preparations will stretch all the way through next Saturday morning, but at this point we've done most...
2008-10-19
501 reads
Uninstalling Software (Sucks) and Why Computers Are Still Slow
I've just recently acquired a new laptop and my resolution is to install no software on it that I'm not...
2008-10-16
677 reads
How Many Drive Letters Do You Use for SQL Server?
I was teaching a private class recently that had both DBA's and network types in the room, one of the...
2008-10-16
825 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