Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
539 reads
A Discussion of SQL Server-Related Topics
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
798 reads
Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
540 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
860 reads
Saving SSMS Settings (Day 28)
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
396 reads
Comparing Query Plans (Day 27)
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
460 reads
A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
703 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
390 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
368 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
311 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