Today Steve reminisces on the early days of SQL Server Central.

How Filters and Sorting can Derail SQL Pagination Performance

by Additional Articles

MSSQLTips.com

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

by Steve Jones

SQLServerCentral.com

T-SQL

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

by Steve Jones

SQLServerCentral.com

T-SQL

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

by Steve Jones

SQLServerCentral.com

Advanced Querying

Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.

Expensive CPUs

by Steve Jones

SQLServerCentral

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()

by Bill Pearson

SQLServerCentral

DAX
Power BI

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