<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Search
Items 1 to 20 of 50
Next 20 >>
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,052 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,395 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,314 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,430 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
2012/09/18
|
Source:
SQLServerCentral.com
|
Category:
fuzzy match
Rating:
|
Discuss
|
Briefcase
|
12,669 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,092 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,837 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
2012/04/09
|
Source:
SQLServerCentral.com
|
Category:
string
Rating:
|
Discuss
|
Briefcase
|
1,786 reads
A google like search
A conceptual proof for a google like search procedure
Read more...
By
Jean Bulinckx
2012/02/02
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
3,083 reads
Find occurence of any value in database!
Search entire database for occurrence of any text!
Read more...
By
Reddy Software Solutions
2012/01/09
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
4,706 reads
Search for a String in all Stored Procedures and beyond?
Search for String Occurence with this script in your stored procedures.
Read more...
By
Mani Singh
2011/10/20
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
4,723 reads
Object Search
Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.
Read more...
By
Sean Smith
2011/10/19
|
Source:
SQLServerCentral.com
|
Category:
object
Rating:
|
Discuss
|
Briefcase
|
2,468 reads
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
Read more...
By
Rafal Skotak
2011/03/02
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
4,667 reads
Searching through SPs, Tables, Views
Find quickly all stored procedures, tables and views that are somehow related to the search term.
Read more...
By
Jano Petras
2011/02/09
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
2,595 reads
Search all columns in every table for a value
This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.
Read more...
By
Michael Davis
2010/11/09
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,355 reads
Find a string in database objects
A very simple way to find a string in database objects and see where it is located in object definition.
Read more...
By
Laurent Michaud
2010/06/21
|
Source:
SQLServerCentral.com
|
Category:
string match
Rating:
|
Discuss
|
Briefcase
|
2,665 reads
Object Search
Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.
Read more...
By
Sean Smith
2011/10/19
|
Source:
SQLServerCentral.com
|
Category:
object
Rating:
|
Discuss
|
Briefcase
|
2,468 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,092 reads
Search all tables for text
This script will help you search all tables for a specific set of text.
Read more...
By
Luis Chiriff
2010/02/15
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
2,627 reads
A Search and Replace Script when Moving Objects from Prod to Test
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
Read more...
By
Ben Kubicek
2010/02/03
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
7,269 reads
Items 1 to 20 of 50
Next 20 >>
Tags
t-sql
(15)
administration
(9)
sql server 2005
(9)
maintenance and management
(8)
utility
(7)
tables
(6)
find
(4)
performance tuning
(4)
string
(4)
columns
(3)
definition
(2)
dynamic sql
(2)
indexing
(2)
maintenance
(2)
stored procedures
(2)
temporary tables
(2)
text
(2)
administrator
(1)
algorithm
(1)
cached execution plan
(1)
character
(1)
clustered
(1)
column
(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 match
(1)
fuzzy-string
(1)
google
(1)
indexed views
(1)
interstorm
(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)
search text
(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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
