My Upcoming Schedule, Come Get Your Learn On!
It’s official, I’ll be speaking at SQLSaturday #63 April 2nd. It is something near and dear to my heart, solid state storage....
2011-02-28
1,355 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command?...
2011-02-28
12 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way...
2011-02-28
3,527 reads
SSAS - Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in...
2011-02-28
5,864 reads
JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,480 reads
SQLskills SQL Server Immersion Training: A Retrospective
Last week I attended the inaugural training event of the new four-week SQL Server Immersion Training offered by Kimberly Tripp...
2011-02-28
2,009 reads
Adventure Works Sample Database Diagrams
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,921 reads
Quests Performance Monitor Counters Poster
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
3,041 reads
SQLskills Immersion Event on Internals and Performance – Day 5
Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...
2011-02-26
1,783 reads
Test Complete – MCM
I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience....
2011-02-25
1,789 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