SQLServerCentral.com Content tagged Miscellaneous

Search All SQL Script Objects in All Databases for Text

Tue, 21 May 2013 06:00:00 UT

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

Function to Split Multivalued Parameter

Mon, 16 Jul 2012 06:00:00 UT

This Function is written to split Multivalued Parameter passed by Reporting Services 2005.

Effectively mapping primary key – foreign key relations

Tue, 15 May 2012 06:00:00 UT

This script maps the primary key - foreign key relations regardless if the column names are the same or not.

A Sudoku solution with set based T-SQL utilizing binary operators

Wed, 21 Dec 2011 07:00:00 UT

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.

Select from stored procedure

Wed, 14 Dec 2011 07:00:00 UT

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.

Clear database - delete all records from a database (updated)

Fri, 09 Dec 2011 07:00:00 UT

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

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.

Generating number sequences with Common Table Expressions

Tue, 04 Oct 2011 06:00:00 UT

The script shows one of ways generating number sequence - this one uses CTE.

How to Test Connectivity for a Linked Server

Fri, 16 Sep 2011 06:00:00 UT

Just one way of testing for a linked server based on data within your database.

Locate primary key - foreign key relations

Wed, 14 Sep 2011 06:00:00 UT

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

Table row count using 3 different ways

Thu, 16 Jun 2011 06:00:00 UT

Three different ways that you can get the count of the rows in a table.

Compare and sync databases with SQL Compare
“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.

Get all user def table info

Mon, 06 Jun 2011 06:00:00 UT

Get space for all user defined table information like size and row counts.

Row count and space used for all tables in database (update)

Wed, 25 May 2011 06:00:00 UT

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).

Get the list of permissions of database object

Tue, 24 May 2011 06:00:00 UT

List permissions for an object in various ways.

Find Text in all columns of all tables in a Database

Thu, 31 Mar 2011 06:00:00 UT

Will find the Table Name, Column Name and the number of occurances some text appears in a database.

Internals and Performance class in Dallas

Fri, 28 Jan 2011 07:00:00 UT

At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...

Find SQL Server TCP/IP Port Number

Thu, 13 May 2010 06:00:00 UT

Script to find the TCP/IP Port number of SQL Instance

Find SQL Server Install Date

Fri, 07 May 2010 06:00:00 UT

Script to find the SQL Server Instance Install Date

Reset count for all alerts

Tue, 22 Dec 2009 07:00:00 UT

To see the frequency of alerts in use, you can reset their fire count. Restart count from zero for all alerts using the propre stored procedures.

Find SQL Server Install Date

Fri, 07 May 2010 06:00:00 UT

Script to find the SQL Server Instance Install Date

BCP Format File Builder

Fri, 14 Aug 2009 06:00:00 UT

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.

Find SQL Server TCP/IP Port Number

Thu, 13 May 2010 06:00:00 UT

Script to find the TCP/IP Port number of SQL Instance

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Wed, 15 Jul 2009 06:00:00 UT

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.

Function to Add Leading 0's (Zeros) to an INT

Thu, 05 Mar 2009 07:00:00 UT

Very simple function code to add leading zeros to a passed in int for a length also passed.

Find Text in all columns of all tables in a Database

Thu, 31 Mar 2011 06:00:00 UT

Will find the Table Name, Column Name and the number of occurances some text appears in a database.

Search All SQL Script Objects in All Databases for Text

Tue, 21 May 2013 06:00:00 UT

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.

Function to Return Date and Time String for File Archiving

Wed, 18 Feb 2009 07:00:00 UT

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.

Yet Another Deleting Duplicate Records (in-place)

Thu, 15 Jan 2009 07:00:00 UT

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Wed, 06 Aug 2008 02:57:05 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Wed, 06 Aug 2008 02:50:45 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.