Another neat idea - The Mentoring Experiment
Another neat idea from the co-founders of SQLServerCentral.com, Steve Jones and Andy Warren, the mentoring experiment has been launched, and...
2011-04-22
1,813 reads
Why having two accounts is a good thing
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
701 reads
A SQL Server Hardware Nugget A Day – Day 21
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
913 reads
Thirty-Three Weeks…
Good day SQLServerCentral!
(Note: This does not have anything to do with SQL; it’s more of a (*gulp*) regular blog…)
Thirty-three weeks. ...
2011-04-21
621 reads
Powershell Day 21
Day 21 SMO programming Part 2 Continue with my earlier blog where I discussed about the information about SMO. Today...
2011-04-21
501 reads
Daily Denali Delight – Day 3
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
796 reads
Daily Denali Delight – Day 2
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
759 reads
Awesome Software/Training Deal!
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
468 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
777 reads
Building an algorithm
When I was in college, and even high school, all of my computer science classes required me to build algorithms....
2011-04-20
1,538 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