Throwback Thursday #1: SQL Inspire
What Is Throwback Thursday?
One of my hobbies is being a turntablist. In high school I took a job just so...
2013-11-14
828 reads
Blog Posts
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this particular file there are around 2...
2013-11-14 (first published: 2013-11-05)
2,110 reads
VMware vCPU Ready Time Equivalent in Hyper-V
Jonathan Keyahias (b | t | l) from SQLskills has released a new blog post outlining the metric that Microsoft’s Hyper-V product...
2013-11-14
1,016 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 2
In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within...
2013-11-13
573 reads
Can't We All Just Get Along?: Personal Development
This isn't a normal post. This one is directed to newer people, those who feel pushed around a bit at...
2013-11-13
395 reads
Create ETL solutions faster with metadata driven development – Session Materials
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
1,157 reads
Create ETL solutions faster with metadata driven development – Session Materials
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
665 reads
Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,500 reads
Potential Backup Software Issues with Read-Only Databases in FULL Recovery
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,030 reads
Powershell in a month – Day 1
I got started on Learn Windows Powershell 3 in a Month of Lunches at lunch one day. Working at home...
2013-11-13
1,841 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