<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
Content with tag
Search
Items 1 to 20 of 42
Next 20 >>
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
Rating:
|
Discuss
|
Briefcase
|
1,133 reads
Find occurence of any value in database!
Search entire database for occurrence of any text!
Read more...
By
Reddy Software Solutions
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
4,607 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
4,407 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
object
Rating:
|
Discuss
|
Briefcase
|
2,280 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
4,515 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,406 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,133 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,520 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
object
Rating:
|
Discuss
|
Briefcase
|
2,280 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
2010/04/02 (first published: 2009/06/11)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
36,223 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,435 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,215 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,133 reads
Search in your T-SQL objects
This procedure searches for your criteria not only in code, but also in objectnames
Read more...
By
Wilfred van Dijk
2009/11/16
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
986 reads
Search a particular text string in all SPs
An easy method to search inherited SP codes for a particular text
Read more...
By
Jason S Wong
2009/10/23
|
Source:
SQLServerCentral.com
|
Category:
search
Rating:
|
Discuss
|
Briefcase
|
988 reads
The Ultimate Table Searcher Mk2
Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.
Read more...
By
Jesse Roberge
2009/10/20
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
800 reads
The Ultimate Column Searcher
Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.
Read more...
By
Jesse Roberge
2009/10/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,251 reads
The Ultimate Index-Less Foreign-Key Finder
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
Read more...
By
Jesse Roberge
2009/10/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,177 reads
The Ultimate Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,132 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,337 reads
Items 1 to 20 of 42
Next 20 >>
Tags
t-sql
(13)
administration
(9)
sql server 2005
(9)
maintenance and management
(8)
t-sql aids
(8)
tables
(6)
utility
(6)
column
(2)
definition
(2)
dynamic sql
(2)
find
(2)
maintenance
(2)
performance
(2)
performance tuning
(2)
stored procedures
(2)
string
(2)
administrator
(1)
cached execution plan
(1)
clr functions
(1)
clr stored procedures
(1)
clr udt
(1)
clustered
(1)
cte
(1)
dependent objects
(1)
dmv
(1)
execute  statement
(1)
find objects
(1)
find string
(1)
find text
(1)
fnord
(1)
foreign keys (fk)
(1)
google
(1)
index
(1)
indexed views
(1)
indexing
(1)
interstorm
(1)
locate
(1)
locate string
(1)
master database
(1)
metadata
(1)
michael davis
(1)
normalization
(1)
object
(1)
object name
(1)
object search
(1)
procedure
(1)
queries
(1)
row_number()
(1)
search text
(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)
temporary table
(1)
temporary tables
(1)
while loop
(1)
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
