DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
2,441 reads
Set Based
GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,079 reads
A new set-based T-SQL solution for Sudoku puzzle
New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.
2016-04-05 (first published: 2015-06-08)
1,881 reads
The Road to Professional Database Development: Set-Based Thinking
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.
2012-03-05
4,317 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-22
497 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
624 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
636 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
1,309 reads
RE: Drill Down Problems
The sample was not showing hidden when I would go through the "Edit Group" route, so this was how I setup my report. But when I went into the XML, it listed the hidden and toggle item properties. I didn't know they wee separate items and thought the Wizards (Edit Group, etc) read and wrote […]
2005-05-25
RE: higher reads when using ADO.NET thatn when using Query Analyzer
I ran the example given (added bigger table to give reads but almost exact) and I could not reproduce the behavior. .Net SqlClient Data Provider RPC:Completed exec dbo.myProc @myparam = 'ALL' 358 readsSQL Query Analyzer SQL:BatchCompleted exec dbo.myProc @myparam = 'ALL' 358 reads kay brought up a good tip also, but it's hard to say what actually […]
2005-01-15
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers