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,108 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,947 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,676 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,298 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,646 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,516 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,108 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 | 669 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 | 571 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,947 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,155 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,175 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,488 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,840 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,623 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,516 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,470 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,990 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)