T-SQL Tuesday #121: Gifts received for this year
It is December again. 2019 has gone by in a flash. I have the honor of hosting the last TSQL Tuesday blog party of the year. This monthly blog...
2019-12-03
9 reads
Azure SQL vs Azure Table Storage
Watch this week's video on YouTube
A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a year...
2019-12-03
11 reads
Azure SQL vs Azure Table Storage
Watch this week's video on YouTube
A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a year...
2019-12-03
16 reads
Azure SQL vs Azure Table Storage
Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...
2019-12-03
2,089 reads
Inspector V2.00 now available
The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The...
2019-12-03
51 reads
Installing Redgate SQL Toolbelt with Chocolatey (video with transcript)
Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line. Spoilers: The command I show in...
2019-12-02
39 reads
Tracking CPU Use Over Time
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
667 reads
SQL Homework – December 2019 – The default trace and the system health session.
I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading
2019-12-17 (first published: 2019-12-02)
450 reads
Presenting for Omaha SQL Server Users Group Dec 4
I’m proud to announce that I’ll be presenting an updated session entitled “Level Up Your Cloud Infrastructure Skills” for the Omaha SQL Server Users Group on December 4th at...
2019-12-02
20 reads
SQL Server 2019 eBook
SQL Server 2019 is ready available for use, but before you download you should review the webinars, white papers and eBook available on the technology (definitely the eBook ??...
2019-12-02
273 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