Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
359 reads
A Discussion of SQL Server-Related Topics
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,432 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
319 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
188 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
359 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
138 reads
Object Explorer Details (Day 21)
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
377 reads
Object Explorer Details (Day 21)
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
123 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
418 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
137 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