﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged Search</title><link>http://www.sqlservercentral.com/</link><description>Content tagged Search posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Get Performance Tips Directly From SQL Server</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/66729/</guid><pubDate>2009/06/11</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/66729/</link></item><item><title>Search all tables for text</title><description><![CDATA[This script will help you search all tables for a specific set of text.]]></description><guid>http://www.sqlservercentral.com/scripts/Search/69345/</guid><pubDate>2010/02/15</pubDate><link>http://www.sqlservercentral.com/scripts/Search/69345/</link></item><item><title>A Search and Replace Script when Moving Objects from Prod to Test</title><description><![CDATA[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. ]]></description><guid>http://www.sqlservercentral.com/articles/Search/69253/</guid><pubDate>2010/02/03</pubDate><link>http://www.sqlservercentral.com/articles/Search/69253/</link></item><item><title>Search all columns in every table for a value</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/SQL/69207/</guid><pubDate>2010/01/25</pubDate><link>http://www.sqlservercentral.com/scripts/SQL/69207/</link></item><item><title>Search in your T-SQL objects</title><description><![CDATA[This procedure searches for your criteria not only in code, but also in objectnames]]></description><guid>http://www.sqlservercentral.com/scripts/Search/68534/</guid><pubDate>2009/11/16</pubDate><link>http://www.sqlservercentral.com/scripts/Search/68534/</link></item><item><title>Search a particular text string in all SPs</title><description><![CDATA[An easy method to search inherited SP codes for a particular text<!-- Too many SQL Servers to keep up with? -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>Too many SQL Servers to keep up with?</strong><br /><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse">Download a free trial</a> of SQL Response to monitor your <br>SQL Servers in just one intuitive interface."The monitoring<br>in SQL Response is excellent." Mike Towery. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Search/68347/</guid><pubDate>2009/10/23</pubDate><link>http://www.sqlservercentral.com/scripts/Search/68347/</link></item><item><title>The Ultimate Table Searcher Mk2</title><description><![CDATA[Searches for tables who's names contain the search string.  Gives Aggregate Size, Rows, Index, and Column information as well.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64870/</guid><pubDate>2009/10/20</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64870/</link></item><item><title>The Ultimate Column Searcher</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/63928/</guid><pubDate>2009/10/16</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/63928/</link></item><item><title>The Ultimate Index-Less Foreign-Key Finder</title><description><![CDATA[Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/68357/</guid><pubDate>2009/10/15</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/68357/</link></item><item><title>The Ultimate Table Searcher</title><description><![CDATA[Searches for tables who's names contain the search string.  Gives Size and Rows information as well.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/63929/</guid><pubDate>2009/10/14</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/63929/</link></item><item><title>The Ultimate Foreign Key Researcher</title><description><![CDATA[Searches for actual and potential foreign key columns for a given primary key reference.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/63509/</guid><pubDate>2009/10/12</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/63509/</link></item><item><title>The Ultimate Precompiled Procedure Searcher</title><description><![CDATA[Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.]]></description><guid>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</guid><pubDate>2009/10/08</pubDate><link>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</link></item><item><title>The Ultimate Object Searcher</title><description><![CDATA[Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/68266/</guid><pubDate>2009/10/06</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/68266/</link></item><item><title>The Ultimate PK-Less / CLIDX-Less Table Finder</title><description><![CDATA[Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64880/</guid><pubDate>2009/10/02</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64880/</link></item><item><title>Searching Unidentified Tables and Columns for Specific Content</title><description><![CDATA[You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67652/</guid><pubDate>2009/07/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67652/</link></item><item><title>Get Performance Tips Directly From SQL Server</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/66729/</guid><pubDate>2009/06/11</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/66729/</link></item><item><title>Object Search</title><description><![CDATA[Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.]]></description><guid>http://www.sqlservercentral.com/scripts/object/66798/</guid><pubDate>2009/06/09</pubDate><link>http://www.sqlservercentral.com/scripts/object/66798/</link></item><item><title>Object Search</title><description><![CDATA[Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.]]></description><guid>http://www.sqlservercentral.com/scripts/object/66798/</guid><pubDate>2009/06/09</pubDate><link>http://www.sqlservercentral.com/scripts/object/66798/</link></item><item><title>search every database on server from a single sp</title><description><![CDATA[i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works]]></description><guid>http://www.sqlservercentral.com/scripts/Search/64962/</guid><pubDate>2008/12/19</pubDate><link>http://www.sqlservercentral.com/scripts/Search/64962/</link></item><item><title>The Ultimate PK-Less / CLIDX-Less Table Finder</title><description><![CDATA[Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/64880/</guid><pubDate>2009/10/02</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/64880/</link></item><item><title>Finding Values With Numerous Columns</title><description><![CDATA[Techniques for finding values in a denormalized table.]]></description><guid>http://www.sqlservercentral.com/articles/Search/64877/</guid><pubDate>2008/12/02</pubDate><link>http://www.sqlservercentral.com/articles/Search/64877/</link></item><item><title>Search for objects in a database</title><description><![CDATA[Find in a flexible way different type of objects on databases.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Search/64828/</guid><pubDate>2008/12/02</pubDate><link>http://www.sqlservercentral.com/scripts/Search/64828/</link></item><item><title>Find a string in compiled objects</title><description><![CDATA[This utility will find strings in procedures, functions, views, and even check constraints.]]></description><guid>http://www.sqlservercentral.com/scripts/Search/64839/</guid><pubDate>2008/10/31</pubDate><link>http://www.sqlservercentral.com/scripts/Search/64839/</link></item><item><title>The Ultimate Table Searcher</title><description><![CDATA[Searches for tables who's names contain the search string.  Gives Size and Rows information as well.]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/63929/</guid><pubDate>2009/10/14</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/63929/</link></item><item><title>Useful Sql Quries</title><description><![CDATA[Searching through system tables.]]></description><guid>http://www.sqlservercentral.com/scripts/Search/63824/</guid><pubDate>2008/10/01</pubDate><link>http://www.sqlservercentral.com/scripts/Search/63824/</link></item><item><title>The Ultimate Precompiled Procedure Searcher</title><description><![CDATA[Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.]]></description><guid>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</guid><pubDate>2009/10/08</pubDate><link>http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/</link></item><item><title>The Ultimate Foreign Key Researcher</title><description><![CDATA[Searches for actual and potential foreign key columns for a given primary key reference.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/63509/</guid><pubDate>2009/10/12</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/63509/</link></item><item><title>Search for a String in all Stored Procedures and beyond?</title><description><![CDATA[Search for String Occurence with this script in your stored procedures.]]></description><guid>http://www.sqlservercentral.com/scripts/Search/63397/</guid><pubDate>2008/07/31</pubDate><link>http://www.sqlservercentral.com/scripts/Search/63397/</link></item><item><title>Search word in sps</title><description><![CDATA[Get the list of sps or functions having a word e.g. &quot;Return&quot;]]></description><guid>http://www.sqlservercentral.com/scripts/Stored+Procedures/63735/</guid><pubDate>2008/07/17</pubDate><link>http://www.sqlservercentral.com/scripts/Stored+Procedures/63735/</link></item><item><title>Dynamic Search Conditions</title><description><![CDATA[ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/62311/</guid><pubDate>2008/03/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/62311/</link></item></channel></rss>