How Filters and Sorting can Derail SQL Pagination Performance
In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.
Tame Those Strings Part 6 - Bending Results
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Tame Those Strings Part 8 - Quoting
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
Tame Those Strings Part 9 - Dynamic SQL
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
Expensive CPUs
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson introduces a subseries surrounding the DAX Text Functions, including LEFT(), RIGHT(), MID(), REPLACE(), and SUBSTITUTE() and breaks out the operational groups of functions involved. Next, he introduces the “Extract and Modify” group of text functions as the focus of this Level. Finally, he identifies and examines each functional member of the “Extract and Modify
Tame Those Strings Part 1 - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
Tame Those Strings! Part 10 - Finding Carriage Returns
Expanding on his series of string manipulation in T-SQL, Steve Jones takes a look at how you go about removing those unseen characters from your strings.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
What is New in SQL Server 2025
Comments posted to this topic are about the item What is New in SQL...
May the Fourth Be With You Fun
Comments posted to this topic are about the item May the Fourth Be With...
Who is Using CAGs?
Comments posted to this topic are about the item Who is Using CAGs?
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers