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
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
This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.
2015-02-18 (first published: 2014-01-25)
646 reads
Easiest way to search for a string in any object within the database.
2013-08-08 (first published: 2013-07-29)
2,286 reads
This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.
2013-06-24 (first published: 2013-05-31)
1,218 reads
Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.
2013-05-30 (first published: 2013-05-22)
1,595 reads
Learn how to search for a value throughout all database tables.
2013-03-14
7,026 reads
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
1,643 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,853 reads
An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008
2014-01-10 (first published: 2012-09-18)
28,692 reads
Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.
2012-05-10 (first published: 2012-04-18)
2,137 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers