Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Miscellaneous
Refine your search with one of the following additional tags (with number of items):
T-SQL Aids
(387)
SQL Server 7, 2000
(4)
chris morton
(1)
prime
(1)
Maintenance and Management
(334)
DBA
(3)
codrakon
(1)
prime number
(1)
SQLInsider Scripts
(131)
Development
(3)
columns
(1)
Puzzle
(1)
Backup / Restore
(51)
nums
(3)
data
(1)
sieve
(1)
Data Warehousing
(41)
Table of Numbers
(3)
Date
(1)
SQL Server 2005 / SQL Server 2008
(1)
Index Management
(34)
tally
(3)
DBA Code
(1)
Stored Procedures
(1)
Lock and Connection Management
(25)
counter
(2)
Foreign Key
(1)
tables
(1)
Mail
(16)
function
(2)
Full-Text Search (2005)
(1)
TIME
(1)
SQL Server 2005
(13)
Table
(2)
games
(1)
Utility
(1)
Replication
(12)
Administration
(1)
Linked Server
(1)
Views
(1)
T-SQL
(8)
Archive File
(1)
Management
(1)
Warehouse
(1)
Advanced Querying
(4)
archiving
(1)
Search for
any
content tagged
Miscellaneous
Add a script
Items 1 to 20 of 837
Next 20 >>
BCP Format File Builder
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
Read more...
By
Paul Hunter
2009/08/14
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005 / SQL Server 2008
Rating:
|
Discuss
|
Briefcase
|
587 reads
Find SQL Server Install Date
Script to find the SQL Server Instance Install Date
Read more...
By
Vijendran R
2009/08/20
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
515 reads
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
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.
Read more...
By
Jesse Roberge
2009/07/15
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
808 reads
Find SQL Server TCP/IP Port Number
Script to find the TCP/IP Port number of SQL Instance
Read more...
By
Vijendran R
2009/07/16
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,076 reads
Function to Add Leading 0's (Zeros) to an INT
Very simple function code to add leading zeros to a passed in int for a length also passed.
Read more...
By
Joshua A. Walker
2009/03/05
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
1,105 reads
Function to Return Date and Time String for File Archiving
This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.
Read more...
By
Joshua A. Walker
2009/02/18
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,056 reads
Find Text in all columns of all tables in a Database
Will find the Table Name, Column Name and the number of occurances some text appears in a database.
Read more...
By
Joshua A. Walker
2009/02/24
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,471 reads
Search All SQL Script Objects in All Databases for Text
Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.
Read more...
By
Joshua A. Walker
2009/02/19
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,019 reads
Yet Another Deleting Duplicate Records (in-place)
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
Read more...
By
Peter Petrov
2009/01/15
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,206 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2005
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
676 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2000
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
Read more...
By
Jesse Roberge
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
351 reads
Proc to Rename a file
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.
Read more...
By
Simon Facer
2008/06/17
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,710 reads
A Sudoku solution with set based T-SQL utilizing binary operators.
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
Read more...
By
Kevin Duan
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,253 reads
Row count and space used for all tables in database (update)
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).
Read more...
By
Rafal S.
2008/05/02
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
8,099 reads
Select from stored procedure
This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.
Read more...
By
Rafal S.
2008/04/23
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,256 reads
Generating number sequences with Common Table Expressions
The script shows one of ways generating number sequence - this one uses CTE
Read more...
By
Rafal S.
2008/03/31
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
863 reads
Generating permutations - procedure
This procedure prepares a query for generating permutations of n-numbers set and executes it.
Read more...
By
Rafal S.
2008/03/18
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
697 reads
Clear database - delete all records from a database (updated)
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
Read more...
By
Rafal S.
2008/04/14
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,440 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 S.
2008/03/12
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,561 reads
Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
Read more...
By
Rafal S.
2008/03/06
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
615 reads
Items 1 to 20 of 837
Next 20 >>
Most popular
Find Text in all columns of all tables in a Database
Will find the Table Name, Column Name and the number of occurances some text appears in a database.
Read more...
By
Joshua A. Walker
2009/02/24
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,471 reads
Find SQL Server TCP/IP Port Number
Script to find the TCP/IP Port number of SQL Instance
Read more...
By
Vijendran R
2009/07/16
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,076 reads
Row count and space used for all tables in database (update)
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).
Read more...
By
Rafal S.
2008/05/02
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
8,099 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use