Brown Bag Lunches/Training - Do They Work?
I'll define a brown bag lunch as a training event held at lunch time where someone on the team does...
2008-09-08
1,104 reads
SQLAndy
Naked Conversations
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
358 reads
Renaming Databases Posted on SQLServerCentral.com
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
296 reads
Vacations
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,110 reads
Performance Tuning Tips From the Consultant Perspective
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
297 reads
Creating Databases Posted on SQLServerCentral.com
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
399 reads
Speakers/Presenters, Can You Answer ALL The Questions?
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
410 reads
Labor Day
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,774 reads
Insufficient Space for a Side by Side Restore - What Do You Do?
I was recently working with a student in a one on one format and one the scenarios he wanted to...
2008-08-28
1,430 reads
Reminder: Upcoming SQL Launch Event in Jacksonville, FL on Sep 12, 2008
The Jacksonville SQL Server Users Group (www.jssug.com) is hosting a SQL 2008 launch event on Friday, Sep 12, 2008 in downtown...
2008-08-27
1,370 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