Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By
In a previous blog written back in June, I showed you how to use the interactive sort option on a...
2010-11-04
1,852 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th, the first Thursday of the month rather than the...
2010-11-04
8 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th,...
2010-11-04
514 reads
Successful Teams: Everyone Performs
By day I'm a DBA. Nights and weekends I'm a junior high youth pastor and Awana commander. I have the...
2010-11-03
1,473 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today we get to talk about chapter 7 in...
2010-11-03
12 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
744 reads
SQLServerPedia Award Votes
This is just another reminder to please vote for my blog post on using PowerShell Remoting with SQL Server. It’s...
2010-11-03
576 reads
How To Participate In The PASS Summit When You Can't Be There
Bummed that you can't go to the PASS Summit in Seattle this year? Turn that frown upside down because there...
2010-11-03
689 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
845 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
974 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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