Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 901    Older >>
 

Search objects in Database

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...
By bpimenta 2014/04/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,394 reads

Script to Get the Database size in GB's

Script to Get the database file size in GB  Read more...
By sathish NS 2015/03/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,712 reads

Use HASHBYTES to identify changes

Use a hash to identify changes and process just the changed rows.  Read more...
By Jim Youmans 2013/11/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,931 reads

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,740 reads

Display the SELECT statement for any table

Found this lovely T-SQL script to display the SELECT statement for any table.  Read more...
By Mehernosh 2013/08/22 | Source: SQLServerCentral.com | Category: select query
Rating: |  Discuss |   Briefcase | 3,171 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,249 reads

Fastest way to find DB object dependencies

One of the fastest ways to find out objects dependencies in SQL Server.  Read more...
By Kshitij Satpute 2015/04/07 | Source: SQLServerCentral.com | Category: dependencies
Rating: |  Discuss |   Briefcase | 3,176 reads

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,600 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,563 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,802 reads

Finding Queries to Tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2015/10/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,428 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,552 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,107 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,550 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,206 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,609 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,680 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,596 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,681 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,463 reads
<< Newer    Items 21 to 40 of 901    Older >>