Spring in Florida
The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere,...
2014-02-27
1,049 reads
Blog Posts
SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It's nice to have...
2014-02-27
1,430 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-27 (first published: 2014-02-24)
3,344 reads
Thinking with Data by Max Shron
DISCLAIMER
I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for...
2014-02-27
1,194 reads
Virtual Lab – Setting up a new VM
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-02-27
1,469 reads
Acadiana SQL Server User Group - Introduction to SQL Server Security Principals and Permissions
Great crowd last night and a great job by organizers Glenda Gable and Jill Joubert for the very first meeting...
2014-02-26
1,010 reads
Colorado SQL Events for March 2014
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-02-26
1,085 reads
Last Backup Times per Database and Backup Type
This script displays the last date and time of each backup type for each database.
It’s useful when you need to...
2014-02-26
507 reads
SSPI Handshake Failed
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error...
2014-02-26 (first published: 2014-02-18)
4,129 reads
Tell Me How I’m Doing: A Fable About the Importance of Giving Feedback
I read a lot of blogs using BlogTrottr as my inbox delivery mechanism, but it has been quite a while since I’ve...
2014-02-26
655 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