Reblog: February 28 to March 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-03-07
850 reads
Blog Posts
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
874 reads
A CLR Application: Deleting Three Billion Rows
In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been...
2014-03-06
1,173 reads
Approachable? Sometimes.
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...
2014-03-06 (first published: 2014-02-25)
1,847 reads
Configuring Native Mode SSRS on local host
OK, so you successfully installed SQL Server and you selected to deploy SQL Server Reporting Services using the default installation...
2014-03-06
17,298 reads
Different approaches of counting number of rows in a table
Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL...
2014-03-06
1,438 reads
Dude, where’s my Power Map?
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes...
2014-03-06 (first published: 2014-02-26)
2,739 reads
How wait statistics are generated
How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them...
2014-03-06
684 reads
How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a...
2014-03-06
695 reads
Omaha SQL Server Users Group Session
Photo from @sqlrus
Tonight I was lucky enough to be able to present to my home SQL Server Users Group in...
2014-03-06
561 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