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.
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
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.
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
In this article by Steve Jones, he shows you how to manipulate strings.
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.
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers