A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
701 reads
SQL Saturday #63 – Dallas: Wrap-up
SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...
2011-04-04
791 reads
A SQL Server Hardware Nugget A Day – Day 3
Lest anyone accuse me of ignoring AMD in this series, I will talk about the AMD Opteron 6100 series processors...
2011-04-03
458 reads
Tampa IT Camp 2011 Lessons Learned Part 2
In part 1 I provide an overview of concept of IT Camp, how the plan was developed by borrowing ideas...
2011-04-03
700 reads
SQL Saturday #63 PPT
The PowerPoint deck from my presentation is here if you want it
http://www.sqlservercentral.com/articles/Presentations/70959/
- Posted using BlogPress from my iPhone
Filed under: Blog...
2011-04-03
859 reads
Powershell Day 3
Day 3 Programming in Powershell Part 1 Now you got some good basic information about Powershell, and some basic commands...
2011-04-03
1,098 reads
View system object definitions
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
633 reads
SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
644 reads
A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
546 reads
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
639 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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