Recover Database using Stellar Repair for MS SQL
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of his databases. The corruption...
2019-05-28
28 reads
Blog Posts
Speaking at Events
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
14 reads
A Lost Day
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
41 reads
How was it done back in the day? T-SQL Tuesday #114
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! ... Continue reading
2019-05-27 (first published: 2019-05-14)
487 reads
Maximum Number of Rows for the Table Value Constructor
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...
2019-05-27 (first published: 2019-05-09)
831 reads
Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-05-27
25 reads
SQL Server Development Best Practices – Webinar
I’m delighted to announce I’ll be giving a webinar for MSSQLTips.com about SQL Server Development Best Practices. Aka writing T-SQL and stuff ?? The webcast is the 13th of...
2019-05-27
43 reads
Weekly reading #15
SQLDay 2019 is gone. The Data Community.PL has now a new goal – it is the SQL Saturday #914 in Torun. The speakers will be announced after July 30th....
2019-05-27
23 reads
Last Weeks Reading (2019-05-26)
It was tremendously extensive week for me (a week ago) when I spent time between two conferences: SQLDay (Wroclaw, Poland) and SQL Saturday #857 (Kiev, Ukraine). I’ve been helping...
2019-05-26
15 reads
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory)....
2019-05-25
46 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