﻿<?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 Scripts tagged Miscellaneous, SQL Server 2005</title><link>http://www.sqlservercentral.com/</link><description>Scripts tagged Miscellaneous, SQL Server 2005 posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Prime Number Table Generator (new ver crunches to 1 Mil in &lt;10.5 sec!)</title><description><![CDATA[Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.]]></description><guid>http://www.sqlservercentral.com/scripts/Advanced+Querying/67436/</guid><pubDate>2009/07/15</pubDate><link>http://www.sqlservercentral.com/scripts/Advanced+Querying/67436/</link></item><item><title>Yet Another Deleting Duplicate Records (in-place)</title><description><![CDATA[Here is another &quot;deleting duplicate records&quot; script, this time in-place, using a uniqueidentifier column.]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/65420/</guid><pubDate>2009/01/15</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/65420/</link></item><item><title>Counter Table (table of numbers) Setter-Upper for SQL Server 2005</title><description><![CDATA[Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/</guid><pubDate>2008/08/05</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/</link></item><item><title>Proc to Rename a file</title><description><![CDATA[A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/63094/</guid><pubDate>2008/06/17</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/63094/</link></item><item><title>A Sudoku solution with set based T-SQL utilizing binary operators.</title><description><![CDATA[A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/62978/</guid><pubDate>2008/06/09</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/62978/</link></item><item><title>Row count and space used for all tables in database (update)</title><description><![CDATA[This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62468/</guid><pubDate>2008/05/02</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62468/</link></item><item><title>Generating number sequences with Common Table Expressions</title><description><![CDATA[The script shows one of ways generating number sequence - this one uses CTE]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62184/</guid><pubDate>2008/03/31</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62184/</link></item><item><title>Clear database - delete all records from a database (updated)</title><description><![CDATA[The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62115/</guid><pubDate>2008/04/14</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62115/</link></item><item><title>Search for a text in all databases</title><description><![CDATA[This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62066/</guid><pubDate>2008/03/12</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62066/</link></item><item><title>Search for a specified GUID (or its part) in all databases (updated)</title><description><![CDATA[This procedure searches for the specified GUID (or its part) in all (or selected one) databases]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62060/</guid><pubDate>2008/03/06</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62060/</link></item><item><title>Sorted views in 2005 and TOP clause</title><description><![CDATA[These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62044/</guid><pubDate>2008/02/22</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62044/</link></item><item><title>Generating combinations 'm elements from n-element set'</title><description><![CDATA[This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.
]]></description><guid>http://www.sqlservercentral.com/scripts/Miscellaneous/62041/</guid><pubDate>2008/04/01</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62041/</link></item><item><title>Generating permutations</title><description><![CDATA[This script shows one on ways of generating permutations.<!-- Join 35,000+ -->
<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_customers_2.htm?utm_source=ssc&utm_medium=rss&utm_content=35000custs_201003&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>Join SQL Backup’s 35,000+ customers to  compress<br>
and strengthen your backups
</strong><br>"SQL Backup will be a REAL boost to any DBA lucky enough <br>
to use it." Jonathan Allen.  <br>
  <a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_customers_2.htm?utm_source=ssc&utm_medium=rss&utm_content=35000custs_201003&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/Miscellaneous/62030/</guid><pubDate>2008/02/27</pubDate><link>http://www.sqlservercentral.com/scripts/Miscellaneous/62030/</link></item></channel></rss>