Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag T-SQL Rss

Search for any content tagged t-sql

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 40 of 894    Older >>
 

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2015/03/17 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 4,440 reads

Simple and efficient way to split string with seperator

Split a string with separator without looping. Can be efficiently used with joins if necessary.  Read more...
By Steven Rao 2013/07/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,534 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2015/05/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,523 reads

Finding queries to tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2013/06/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,282 reads

Search all stored procedures on all databases

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.  Read more...
By Jim Youmans 2013/05/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,522 reads

Run SQL code on each database

You can use this to run a script/s on multiple databases  Read more...
By Ashley McLellan 2015/02/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,010 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2015/05/13 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 2,121 reads

Copy Sql Objects

Copy tables, procedures, functions and view from one schema and another schema.  Read more...
By Vinay Kumar 2013/03/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,159 reads

Copy Table

Copy tables from one schema to another schema.  Read more...
By Vinay Kumar 2013/04/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,543 reads

Create Table with T-SQL

Generate create table statement using T-SQL.  Read more...
By Vinay Kumar 2013/04/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,631 reads

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,557 reads

Transpose Query Output

script to return query result transposed.  Read more...
By Florian Cechi 2013/02/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,642 reads

Get Database Size

Know you database size  Read more...
By Vinay Kumar 2013/02/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,333 reads

Open transactions on a database

This script will show you all open transactions from any query windows.  Read more...
By kyle.eldridge 2013/08/29 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 2,734 reads

T-SQL Bulk Insert

T-SQL that allows you to import tab delimited text file into correct table based on file name.  Read more...
By Ervin Santiago 2013/02/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,927 reads

Number of Working Days

Number of workings days in a month minus weekends and holidays.  Read more...
By Ervin Santiago 2013/02/08 | Source: SQLServerCentral.com | Category: workdays
Rating: |  Discuss |   Briefcase | 1,435 reads

Manipulate Horizontal Hierarchy with UNPIVOT

Convert Horizontal Hierarchy to vertical Hierarchy.  Read more...
By Bernabe Diaz 2012/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 968 reads

Print Text Month Calendar

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.   Read more...
By Bernabe Diaz 2012/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,634 reads

Deleting Duplicate Records

In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.   Read more...
By Shankar Walvekar 2012/11/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,036 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,631 reads
<< Newer    Items 21 to 40 of 894    Older >>