SQLServerCentral.com Scripts tagged T-SQL

Finding queries to tune

Tue, 11 Jun 2013 06:00:00 UT

A query to help identify queries that need some tuning.

Search all stored procedures on all databases

Thu, 30 May 2013 06:00:00 UT

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.

Run SQL code on each database

Wed, 10 Apr 2013 06:00:00 UT

You can use this to run a script/s on multiple databases

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Backup all SSAS databases using TSQL

Thu, 28 Mar 2013 06:00:00 UT

Enumerates and backups all SSAS DB's

Copy Sql Objects

Fri, 29 Mar 2013 06:00:00 UT

Copy tables, procedures, functions and view from one schema and another schema.

Copy Table

Wed, 03 Apr 2013 06:00:00 UT

Copy tables from one schema to another schema.

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.

Create Table with T-SQL

Mon, 01 Apr 2013 06:00:00 UT

Generate create table statement using T-SQL.

Converting to datetime a char field with several possible date formats

Thu, 21 Feb 2013 07:00:00 UT

Converting to datetime a char field having several possible date formats

Transpose Query Output

Fri, 22 Feb 2013 07:00:00 UT

script to return query result transposed.

Get Database Size

Mon, 18 Feb 2013 07:00:00 UT

Know you database size

Open transactions on a database

Wed, 30 Jan 2013 07:00:00 UT

This script will show you all open transactions from any query windows.

T-SQL Bulk Insert

Thu, 07 Feb 2013 07:00:00 UT

T-SQL that allows you to import tab delimited text file into correct table based on file name.

Number of Working Days

Fri, 08 Feb 2013 07:00:00 UT

Number of workings days in a month minus weekends and holidays.

Manipulate Horizontal Hierarchy with UNPIVOT

Thu, 20 Dec 2012 07:00:00 UT

Convert Horizontal Hierarchy to vertical Hierarchy.

Print Text Month Calendar

Thu, 29 Nov 2012 07:00:00 UT

This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.

Deleting Duplicate Records

Tue, 20 Nov 2012 07:00:00 UT

In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.

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.

Scripting CREATE INDEX Statements Automatically From Your Tables

Tue, 27 Nov 2012 07:00:00 UT

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.

SCD Implementation with TSQL

Tue, 13 Nov 2012 07:00:00 UT

ETL for a SCD using only TSQL, without hash functions

Create A Folder With T-SQL

Tue, 16 Oct 2012 06:00:00 UT

Pass a folder name to this SP and it will create the folder for you.

Script to get an ordered list of all stored procedures with parameters

Tue, 14 Aug 2012 06:00:00 UT

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.

Print The Calendar 2

Fri, 10 Aug 2012 06:00:00 UT

This script will print the calendar from the given date.

Calculate alphabetic sequence

Wed, 08 Aug 2012 06:00:00 UT

This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ

Check Used Table Space for User Defined Tables

Wed, 11 Jul 2012 06:00:00 UT

Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.

Delete old backup

Tue, 03 Jul 2012 06:00:00 UT

Delete old backup files on a prespecified folder.

Use your own optimizer to tune queries

Thu, 07 Jun 2012 06:00:00 UT

Use your own optimizer to tune queries

Get a range of numbers

Fri, 05 Oct 2012 06:00:00 UT

If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..

How to query dBase .dbf from SQL 2012 64-bit

Wed, 09 May 2012 06:00:00 UT

Query dBase .dbf Files From SQL 2012 64-bit.

Swiss Cheese!

Thu, 26 Apr 2012 06:00:00 UT

Are you trying to determine the gaps in a numerical sequence?

Did you say denormalize, why?

Wed, 25 Apr 2012 06:00:00 UT

How to display data from 1-to-many in a single record!

Script to get database restore history

Fri, 16 Mar 2012 06:00:00 UT

T-SQL to get restore history of SQL databases.