SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,229 reads
Blog Posts
Suggestion for SQL Prompt and SQL Test (Red-Gate)
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous...
2014-03-03
529 reads
Upcoming Conferences: SQLSaturdays in Denmark and Portugal. – Presenting In-Memory OLTP Deep-Dive for Administrators
(de)
Im März und April finden 2 europäischen SQLSaturdays statt, die Potential zu einem Geheimtipp haben:
Am 29. März in Kopenhagen, Dänemark
...
2014-03-03
824 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,082 reads
Fun in DateTime Calculations
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-02
720 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
49 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
48 reads
Friday Followup For February 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-28
1,132 reads
PASS, Evangelism, Goals, Dreams
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS...
2014-02-28
1,298 reads
PowerShell – Export SQL Data to Excel with Powershell
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some...
2014-02-28 (first published: 2014-02-24)
5,059 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