XQuery for the Non-Expert – Value
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-22
2,035 reads
Do Foreign Key Constraints Help Performance?
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,703 reads
SQL PASS 2010 Summit – Recap
The sessions are over, and the post-cons are done; the vendor parties are but a memory, and the #sqlkaraoke music...
2010-11-22
1,153 reads
Un-SQL Friday 001: Branding
Since it’s Sunday (almost Monday), I thought I would chip into Un-SQL Friday. Before I get down to brass tacks,...
2010-11-22
1,045 reads
Quite Time
It’s vacation week for me. Everything’s scheduled for SQLServerCentral, and my family is taking our annual ski break for Thanksgiving....
2010-11-22
703 reads
SSIS Denali Data Flow Grouping
There have been several usability features that have been added to SSIS in the latest CTP.One of these features is...
2010-11-22
838 reads
Guest Vs. Host Clustering Virtual Machines: Speaking Tuesday 23rd November at Montreal Tech Days
I will be replacing speaker Steven Robidas on Tuesday, 23 November at Microsoft TechDays.ca Montreal. The discussion will be on...
2010-11-21
645 reads
Un-SQL Friday: Personal Branding – Don’t Bother
My friend Jen McCown of MidnightDBA fame issued a challenge last week called “Un-SQL Friday”. The inaugural topic is on...
2010-11-21
706 reads
What are you thankful for?
About this time last year, Digineer had an internal event where we could share messages of thanks. These messages were...
2010-11-21
588 reads
SQLSaturday#59 - It's A Wrap! - Summary of Our Saturday...
SQLSaturday#59 went off without a hitch! It was one awesome fun-filled day with our great speakers, sponsors, volunteers, and hundreds...
2010-11-21
1,156 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