Looking Back at SQLRally Orlando
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
652 reads
Oh ****!
Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...
2011-05-25
920 reads
SQL Treeo – Create custom folders in SSMS
SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within...
2011-05-25
972 reads
SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
677 reads
The Ties that Bind Us....Community, People, Exceptional DBAs...
Hi, All. Just some thoughts on a passing scene. Didn't expect to blog today. Many projects in the queue, but...
2011-05-25
1,311 reads
Monitor your SQL Server Agent Proxies Using PowerShell
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,226 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
961 reads
My advanced SQL Server Performance Troubleshooting workshop goes to the international level!
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,627 reads
Fun with Light Bulbs
I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...
2011-05-24
925 reads
Pray For Me…I’m Writing the Bible!
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
565 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