Get SQL Scripts Manager for Free
Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes...
2010-12-23
742 reads
PASS Summit 2010 Session Eval Results
Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the...
2010-12-23
1,049 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
508 reads
PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
788 reads
PASS Summit 2010 Survey Results
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
800 reads
Filling in Data Potholes with Recursive CTEs
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,149 reads
Spreading the DBA Gospel (from Old English, god spell "good news")
There are times when I wonder why I get so few comments on this blog, however there are assumptions I...
2010-12-23
762 reads
Updated SQLRally Flyer
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
718 reads
Lunch Story #3–No Free Sandwiches
This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...
2010-12-23
561 reads
How To Choose A Topic For Speaking
“The human brain starts working the moment you are born and never stops until you stand up to speak in...
2010-12-23
1,187 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
Alamat Kantor BCA KCU Subang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Alamat Kantor BCA KCU Purwakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
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