Viewing 15 posts - 46 through 60 (of 499 total)
Steve Jones - SSC Editor (7/20/2016)
g.britton (7/20/2016)
Hey Steve, I just noticed that, after connecting to this database, the account doesn't have EXECUTE permission on at least one PROC:uspGetWhereUsedProductID
Better? Granted exec...
July 20, 2016 at 5:29 pm
Hey Steve, I just noticed that, after connecting to this database, the account doesn't have EXECUTE permission on at least one PROC:
uspGetWhereUsedProductID
July 20, 2016 at 7:13 am
FWIW I dug into this a while back. For any query of the form:
select count(<some constant>) from sometable
the execution plan, on the Stream Aggregate operator, shows an expression aggregate...
July 13, 2016 at 8:28 am
Alan.B (6/23/2016)[snip]
Thanks for all the detail, Alan. It really helps. I suspect the mdq.ngrams function could easily be improved (could be multi-threaded, e.g.) though it's probably not a...
June 23, 2016 at 1:42 pm
A little off-topic, but Master Data Services comes with CLR-functions that do N-Grams and other nice things. Here's a reference on that:
Regular Expressions, advanced string matching and new Split...
June 23, 2016 at 11:58 am
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 component.
see...
June 23, 2016 at 11:50 am
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 6:30 am
Question: is there an on-prem version of this? I'm in banking which is heavily regulated and generally paranoid (and rightly so!) We have an on-prem cloud for server/database...
June 22, 2016 at 6:55 am
obouda (6/17/2016)
g.britton (6/17/2016)
Also, to be clear, there are highly useful features in many SQL versions that are not supported by others. We use them nonetheless
We use them too -...
June 17, 2016 at 9:24 am
obouda (6/16/2016)
g.britton (6/16/2016)
obouda (6/13/2016)
I vote for the CTE/subquery approach.The day you're porting your SQL to another database engine, e.g. ORACLE, you'll damn all of the MSSQL-specific code 🙂
I have a...
June 17, 2016 at 4:35 am
obouda (6/13/2016)
I vote for the CTE/subquery approach.The day you're porting your SQL to another database engine, e.g. ORACLE, you'll damn all of the MSSQL-specific code 🙂
I have a feeling that...
June 16, 2016 at 9:36 am
Bosko Vukov (6/13/2016)
June 13, 2016 at 2:01 pm
the sqlist (6/13/2016)
Now, that's interesting! I'd be really curious to see how you do that.
Simple, I am connecting to the source sever, whatever platform it may be, querying it,...
June 13, 2016 at 9:52 am
the sqlist (6/13/2016)
June 13, 2016 at 9:02 am
Jeff Moden (6/13/2016)
June 13, 2016 at 7:44 am
Viewing 15 posts - 46 through 60 (of 499 total)