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 62    Older >>
 

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,919 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,605 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,272 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,592 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 | 569 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,475 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 3,119 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 | 666 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 | 561 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,919 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,147 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,172 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,486 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,838 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,511 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,618 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,475 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,449 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,987 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 3,119 reads
   Items 1 to 20 of 62    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)