New book from Pragmatic Works in the "works"...
Hey folks, Just a quick preview that we’re hard at work again on a new book with Wiley publishing focused...
2010-11-21
500 reads
New Video Blogs
Hey there folks! I am sorry it has been about a week without an entry.I have been on planes all...
2010-11-21
329 reads
Where will I be?
After the great time everyone had at the PASS Summit this past week I am getting asked more and more...
2010-11-21
370 reads
XQuery for the Non-Expert – Query
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-21
1,265 reads
XQuery for the Non-Expert – Nodes
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-20
950 reads
Un-SQL Friday 001 : Branding for Business
I really like Jen’s (MidnightDBA,#sqlawesomesauce) idea for the first Un-SQL Friday. I was struggling with the topic and had to read some of the posts from earlier today. No...
2010-11-20
9 reads
Un-SQL Friday 001 : Branding for Business
I really like Jen’s (MidnightDBA,#sqlawesomesauce) idea for the first Un-SQL Friday. I was struggling with the topic and had to...
2010-11-20
925 reads
Un-SQL Friday: Branding
So looks like we have another blog party on our hands, this time courtesy of Jen McCown (Blog | Twitter), one...
2010-11-19
1,855 reads
Don’t Abuse the Use Statement
I ran across this article in Visual Studio Magazine that tracks the source of a missing object to an embedded...
2010-11-19
559 reads
Un-SQL Friday: Branding?
Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...
2010-11-19
668 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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