T-SQL Tuesday #48 – My take on the cloud
So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...
2013-11-13
628 reads
Blog Posts
Who’s on call
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...
2013-11-13
594 reads
Cargo Cult Data Professionals
Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...
2013-11-12
981 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...
2013-11-12
7 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host...
2013-11-12
778 reads
Index Fragmentation : Quick Tip
Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...
2013-11-12
432 reads
In-Memory OLTP and the Identity Column
Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...
2013-11-12
1,523 reads
Loadbalancing SQLServer
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
3,499 reads
Lock Pages in Memory in SQL Server on VMware – Why or Why Not
Two weeks ago I presented my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” at the SQL PASS...
2013-11-12 (first published: 2013-11-04)
3,668 reads
More Azure Goodies
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...
2013-11-12 (first published: 2013-11-05)
1,784 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