Searching Complex JSON Data
Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...
2019-02-26
937 reads
Blog Posts
The Reader’s Choice Awards are Taking Nominations
If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....
2019-02-26
889 reads
Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
243 reads
What Does the Undocumented UNCOMPRESS Function Do?
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
1,020 reads
Workload analysis with WorkloadTools
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
582 reads
Friend of Red Gate
I’ve been a champion of Red Gate’s tools for years. Quite simply, they help me get work done quicker. They...
2019-02-25
165 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2019-02-25 (first published: 2019-02-02)
2,567 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from...
2019-02-25
14 reads
Imp Linux Commands
Important Linux Commands 1. uname -a: To know what version of unix we are using 2. hostname: System name 3....
2019-02-25
363 reads
Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,177 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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