Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Search Rss

   Items 1 to 20 of 63    Older >>
 

String Search

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.  Read more...
By Sean Smith 2014/10/22 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,197 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,948 reads

Searching for Strings in SQL Server Databases

Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.  Read more...
By Additional Articles 2014/05/01 | Source: SimpleTalk | Category: search
Rating:  Rate this |   Briefcase | 7,678 reads

Search objects in Database

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...
By bpimenta 2014/04/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,300 reads

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...  Read more...
By Dwain Camps 2014/04/07 | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 16,658 reads

NameSQLinConfioIgnite

This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.  Read more...
By Thomas Keller 2014/02/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 573 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,523 reads

String Search

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.  Read more...
By Sean Smith 2014/10/22 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,197 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 671 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 572 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,948 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,157 reads

Locate a column across databases

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.  Read more...
Rating: |  Discuss |   Briefcase | 1,176 reads

Search all stored procedures on all databases

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.  Read more...
By Jim Youmans 2013/05/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,489 reads

Search for a Value Throughout Your Database

Learn how to search for a value throughout all database tables.  Read more...
By Gaurav Goel 2013/03/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,841 reads

Query all objects created or modified after specified date

This script will query across all databases, returning a result of objects recently created or modified.  Read more...
By Eric Russell 2012/12/21 | Source: SQLServerCentral.com | Category: objects
Rating: |  Discuss |   Briefcase | 1,520 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,624 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,523 reads

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,474 reads

sp_Find2

Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.  Read more...
By Said Khorramshahgol 2012/05/10 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,992 reads
   Items 1 to 20 of 63    Older >>
 
Tags
t-sql (17)    
administration (9)    
sql server 2005 (9)    
maintenance and management (8)    
utility (7)    
tables (6)    
performance tuning (5)    
find (4)    
string (4)    
columns (3)    
definition (2)    
dynamic sql (2)    
fuzzy match (2)    
indexing (2)    
maintenance (2)    
stored procedures (2)    
temporary tables (2)    
text (2)    
administrator (1)    
algorithm (1)    
cached execution plan (1)    
character (1)    
clustered index (1)    
column (1)    
confio (1)    
cte (1)    
damerau-levenshtein (1)    
data (1)    
database (1)    
dependent objects (1)    
deployment (1)    
dmv (1)    
edit distance (1)    
execute  statement (1)    
find objects (1)    
find string (1)    
find text (1)    
fnord (1)    
foreign keys (fk) (1)    
fuzzy-string (1)    
google (1)    
ignite (1)    
indexed views (1)    
interstorm (1)    
like (1)    
locate (1)    
locate string (1)    
lookup (1)    
master database (1)    
metadata (1)    
michael davis (1)    
modified (1)    
normalization (1)    
object (1)    
object name (1)    
object search (1)    
objects (1)    
procedure (1)    
queries (1)    
row_number() (1)    
sql like search (1)    
sql search (1)    
sql server (1)    
sqlclr (1)    
string manipulation (1)    
string match (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
system development life cycle (1)    
troubleshooting (1)    
while loop (1)    
word (1)