Viewing 15 posts - 631 through 645 (of 2,458 total)
g.britton (6/23/2016)
Alan.B (6/23/2016)
g.britton (6/23/2016)
virtually nothing about the subject in SQL Server
Except for Integration Services that is. Fuzzy Lookup and Fuzzy Grouping use q-grams: n-grams with a distance...
June 23, 2016 at 1:16 pm
Y.B. (6/23/2016)
June 23, 2016 at 11:01 am
Eirikur Eiriksson (6/23/2016)
Nice piece and very good work Alan!😎
Thanks you sir! 😎
June 23, 2016 at 11:00 am
g.britton (6/23/2016)
virtually nothing about the subject in SQL Server
Except for Integration Services that is. Fuzzy Lookup and Fuzzy Grouping use q-grams: n-grams with a distance component.
June 23, 2016 at 11:00 am
David.Poole (6/23/2016)
Is the CTE tally table to encapsulate the tally table in a single function for when there isn't...
June 23, 2016 at 10:38 am
ChrisM@Work (6/22/2016)
Excellent writeup Alan, thanks for posting this. I had no idea about n-grams, despite having used them for fuzzy-matching for years.
Thanks Chris!
Regarding N-Grams - My second SSC artcicle,...
June 22, 2016 at 12:42 pm
Solomon Rutzky (6/20/2016)
June 21, 2016 at 1:50 pm
Con Alexis thank you sir. That's what I was looking for. Sorry for the late reply, yesterday was my birthday.
Luis. It's for an article I'm working on. I have a...
June 18, 2016 at 12:17 pm
manie (6/17/2016)
Excellent script and thanks a lot for this. I will definitely use it a lot. I would like to go through the script at leisure time and might...
June 17, 2016 at 5:36 am
Another way...
SELECT
ROW_NUMBER() OVER (ORDER BY x.value('.','varchar(100)')), -- only if you want a row number
x.query('.')
FROM #Test t
CROSS APPLY t.SomeXml.nodes('/Parent') a(x);
June 16, 2016 at 8:18 pm
Good article Mike. Informative, precise and tother the point.
June 15, 2016 at 6:39 am
I was looking for any advice as to how I could get the most out of this event and future ones in terms of technical information exchange
Forgive me for being...
June 14, 2016 at 7:53 pm
If you want to make the performance even better you can create a table that stores the required start/end dates and write a function uses it. In the example below...
June 14, 2016 at 11:34 am
Great article, I love the series!
For Microsoft Data Mining you need to purchase the Enterprise or the Business Intelligence Editions.
Not any more. Now Developer Edition is free for...
June 14, 2016 at 8:26 am
I'm going to see if I can do this. In the meantime, if anyone else wants to try I've created some more usable sample data.
SET NOCOUNT ON;
IF OBJECT_ID('tempdb..#Products') ...
June 13, 2016 at 8:35 pm
Viewing 15 posts - 631 through 645 (of 2,458 total)