Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2016-02-12 (first published: 2014-04-07)
43,617 reads
SQL LIKE SEARCH
RE: Help needed with query/sp
The error message is correct...look at your FROM:FROM ((tblApVendor INNER JOIN tblApHistHeader ON tblApVendor.VendorID = tblApHistHeader.VendorId) INNER JOIN tblApCheckHist ON (tblApHistHeader.InvoiceDate = tblApCheckHist.InvoiceDate) AND (tblApHistHeader.InvoiceNum = tblApCheckHist.InvoiceNum) AND (tblApHistHeader.VendorId = tblApCheckHist.VendorID)) INNER JOIN (tblApHistDetail INNER JOIN tblGlAcctHdr ON tblApHistDetail.GLAcct = tblGlAcctHdr.AcctId) ON tblApHistHeader.TransId = tblApHistDetail.TransID There's no table or table […]
2004-03-24
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