Locking and Blocking from Joe Webb – DevConnections
Locking should be simple, right? You need to access a row or table and you get a lock. Oh yeah,...
2011-03-29
697 reads
Speaking at SQL Saturday #68 on Women in Technology
I am excited that I get to speak at SQL Saturday #68 on April 9. If you live close to...
2011-03-29
566 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...
2011-03-29
10 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain...
2011-03-29
918 reads
MCM Exam – Take 2
Yesterday, I went in for my re-take of the MCM written exam. If you recall, I failed the exam last...
2011-03-29
576 reads
#SQLSat67… it’s mystery is only exceeded by it’s power.
We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix. To recap...
2011-03-29
681 reads
On Leadership - Lead from the Front
This topic actually came up at SQL Saturday #70 - Columbia, SC. I spent the first 15 years of my life...
2011-03-29
2,164 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
856 reads
Oracle Drops the Bomb
The below information has been taken from SSWUG.org.
Oracle Drops the Bomb
Since the purchase of Sun and it’s holdings by Oracle...
2011-03-28
820 reads
MidnightDBA: We do a lot
We do a lot of things. It’s difficult to explain all the things we do to people. So I made...
2011-03-28
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