SQL Saturday 277 RVA Lessons Learned
Once again it is an honor to attend such a great event and meet up with other like minded geeks....
2014-03-24
478 reads
TheSqlPro.com - Ayman El-Ghazali
[SQL Snacks Video] The Basics of Joins
This is a special edition for SQL Snacks. It is one (of many hopefully) SQL Snacks that has been recorded...
2014-03-10
920 reads
SQL Saturday #277 Richmond – Covering new ground
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
599 reads
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
647 reads
[SQL Snacks Video] Importance of COPY_ONLY Backups
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
691 reads
[SQL Snacks Video] Tail Log Backup and Recovery Demo
In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery...
2014-01-16
641 reads
[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!
To snack lovers every where now you can consume SQL Learning the same way, in Snack Size! Introducing the new...
2014-01-16
569 reads
[Video] ApexSQL Log – Software Review
Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery....
2014-01-08
800 reads
SQL Server 2012 ???? ??????? ????? ??
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2012....
2013-12-18
2,217 reads
TheSQLPro YouTube Channel
That’s right, it’s time to take this blog up a notch! Last week I posted a video about using Hyper-V...
2013-12-11
614 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