SQL Server 2008 R2 System View Map
It’s a map!Have you been looking for something inside the system views of SQL Server 2007 R2 and haven’t known...
2010-12-10
462 reads
IT Education Part 2
For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...
2010-12-10
701 reads
12 Days of SQL, On the 2nd Day of SQL…
Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any...
2010-12-10
782 reads
SQL Saturday #45 Cancelled
I hate not living up to commitments. It really, really bothers me and I have tried hard in my career...
2010-12-10
649 reads
2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)
Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community
Summit in Seattle last year. Since this...
2010-12-10
1,451 reads
SELECT TOP 3 SQLBOOKS FROM 2010
This is just a short post for a Friday. This is my list of the Top 3 SQL Server books...
2010-12-10
963 reads
Free SQL Server Training for the Week of December 13, 2010
I may end up missing this one next week... it all depends on when the baby comes. 🙂
Tuesday
PASS Application Development...
2010-12-10
1,017 reads
Blog Under Some Repairs
Cracked Up
If you’ve been trying to come to the blog lately, you may have noticed a few errors connecting. Resources...
2010-12-10
331 reads
Presenting at PASS AppDev Virtual Chapter
Join me next Tuesday, December 14th at 11:00am CST as I present a webcast on behalf of the PASS AppDev...
2010-12-10
646 reads
The 2011 SQL Saturday Schedule is Filling Up
I have been trying to figure out where to go in 2011 for SQL Saturdays, especially as Red Gate is...
2010-12-10
714 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