Nasty Fast N-Grams (Part 1): Character-Level Unigrams
An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.
2018-11-22 (first published: 2016-06-23)
11,677 reads
String Function
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
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
940 reads
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,008 reads
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
3,620 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
RE: excluding fields in my SELECT from the GROUP BY clause
HelloReplie for Antares686 as requested : NdocNmdocCodigoQtPvValorValor_custoDescMargemComissão1Factura 20180ANB-1 12568,3510487,67787,20+0 25,74861Factura 20180ANB-2 24008,3520040148800+0 25,74861Factura 22520ANB-1 15008,25123758572,54950+0 30,72691Factura 22520ANB-2 15008,251237585800+0 30,66671Factura 24020ANB-1 25005125008581,85250+0 31,34521Factura 24020ANB-1 31005,51705010641,49710+0 37,58661Factura 24040ANB-1 13008104006290,67010+0 39,51281Factura 24040ANB-2 12008960061200+0 36,251Factura 24040ANB-3 860868804162,40+0 39,51Factura 24040ANB-4 150081200076500+0 36,251Factura 24520ANB01-04 310061860011791,07010+0 36,60721Factura 27640ANB-1 420625201377,60+0 45,33341Factura 27640ANB-2 1290677404231,20+0 45,33341Factura 27670ANB-1 32006192009123,92960+0 52,47961Factura 27670ANB-2 22006132007026,55140+0 46,76861Factura 27670ANB-2 24006144007665,32880+0 46,76861Factura 27730ANB-1 10805,4583231860+0 45,37041Factura 27730ANB-2 8205,4442824190+0 45,37041Factura PRV108-1 351072457018145,310040+0 26,14861Factura PRV108-2 48007,937920278880+0 26,45571Factura PRV108-3 70007,95530041006,8820+0 25,84664Nota de Crédito NSINDEMNIZ 112000-12000-0,652870+0 0-4804Nota de Crédito NSRAPPEL 141217,49-41217,4900+0 0-1648,69960 0000 0029 4693853362,79274200,11217126,3883 775,8179-2128,6996that is the result , but i need the result like this :for this Client i need only one line with the SUM of "Valor" ; "Valor_custo";"Comissões"and "Margem" , where "Valor" as Sails;"Valor_custo" as Cost; "comissões" as comissions and "margem" as benefits.I hope you understand better […]
2005-01-11
RE: DBCC DBREINDEX and MDF file size
I have done the DBCC DBREINDEX on a 180+ GB database. It did not increase the database (.mdf) file. It DID increase the log (.ldf) file by quite a lot.The end result was that the .mdf file was SMALLER and the .ldf was LARGER. Why? Well the .mdf has the index data and the reason […]
2004-10-22
T-SQL works in QA but fails when part of a job
HI, the title says it all really, the update statement is below and i would be greatful for any comments on why this happens. thanks, ade --Change Links from class to course UPDATE t1 SET t1.e_parent = t2.e_id FROM dbo.capd_moduleenrolment t1 LEFT OUTER JOIN dbo.capd_examsubjectentry t6 ON t6.ese_id = t1.e_id LEFT OUTER JOIN dbo.capd_moduleenrolment t5 […]
2004-10-19
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