SQL Lunch #40 - Mirroring: The Bear Necessities
I am excited to announce a new speaker to the SQL Lunch, Ryan Adams. Ryan will be discussing Database Mirroring...
2010-10-18
774 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-18
3,167 reads
SSWUG Fall 2010 Virtual Conference This Week
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a...
2010-10-18
565 reads
What I Did This Weekend
About two weeks ago my good friend and former colleague Justin Hostettler-Davie -JHD (Blog | Twitter) asked me via my wife...
2010-10-18
780 reads
SQLSaturday #59 - Speaker Interview #5 with Karen Lopez
SQLSaturday #59 - Speaker Interview #5 with Karen Lopez, (aka datachick)
Let’s trek up North to the great city of Toronto, Canada,...
2010-10-18
1,932 reads
Copyright
This is actually amazing. A talk on what YouTube does with copyright and how they view it, from TED. It’s...
2010-10-18
1,125 reads
Give Back and Get Free Tools to Do So
SQL Server MVP Arnie Rowland (blog | twitter) has been running a project, Project Phoenix, to benefit unemployed/underemployed developers who are striving to do...
2010-10-17
573 reads
When Times are Tough, Do You Rise to the Occasion?
This is a reprint of my editorial in Database Weekly.
Scenario One: The new third-party application, purchased by your company without...
2010-10-17
394 reads
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
2010-10-16
1,552 reads
Return Indexes for a Particular Table using TSQL
I posted a blog recently about returning a listing of all indexes for database, which is good if you want...
2010-10-16
1,163 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