SQLServerCentral is supported by Red Gate Software Ltd.
 
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 T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (38)     Date Manipulation (3)     Duplicate Indexes (1)     Restore (1)    
Administration (35)     Datetime Manipulation (3)     Encode (1)     Role (1)    
Maintenance and Management (25)     Performance testing (3)     Extended Stored Procedures (1)     Running aggregate (1)    
T-SQL Aids (25)     Space Usage (3)     Extract, Transform, Load (ETL) (1)     Running Totals (1)    
Utility (24)     Table (3)     fall on friday (1)     script (1)    
Maintenance (21)     Text matching (3)     find foreign key using SQL (1)     Script Generator (1)    
Advanced Querying (11)     2-Dimensional Arrays (2)     foreign key constraints (1)     scripting (1)    
Performance Tuning (11)     Buffer Cache (2)     foreign keys (1)     Selectivity (1)    
Search (11)     column (2)     function (1)     Service Broker (1)    
String Manipulation (11)     duplicate records (2)     Geometry (1)     sieve (1)    
Admin (10)     games (2)     GPS (1)     source control (1)    
Development (10)     GRANT (2)     Grouping VARCHAR Columns (1)     sp_msforeachdb (1)    
Indexing (10)     Index Usage (2)     growth trend (1)     Spherical coordinates (1)    
Index Management (9)     Lock and Connection Management (2)     Guest User (1)     SQL (1)    
Indexes (9)     Permissions (2)     IDENTITY (1)     SQL Permissions (1)    
SQL Server 7, 2000 (9)     Scalar-valued Functions (2)     Index Tuning (1)     sql query (1)    
Miscellaneous (8)     sys.dm_exec_query_plan (2)     Indexed Views (1)     SQL Script (1)    
nums (8)     sys.dm_exec_requests (2)     Insert Update Stored Procedure Generation (1)     SQL Server 2005 / SQL Server 2008 (1)    
SQLInsider Scripts (8)     sys.dm_exec_sessions (2)     Jobs (1)     SQL Server 2008 (1)    
Table of Numbers (8)     sys.dm_exec_sql_text (2)     Locking (1)     SQLAgent (1)    
tally (8)     sys.dm_os_buffer_descriptors (2)     Logins (1)     Stored Procedure Template (1)    
automated DBA (7)     sys.partitions (2)     Management (1)     String formatting (1)    
counter (7)     Troubleshooting (2)     MERGE (1)     sys.dm_db_index_usage_stats (1)    
pivot (7)     User Defined Function (UDF) (2)     mirror (1)     sys.dm_db_missing_index_details (1)    
Storage (7)     ::fn_listextendedproperty (1)     Missing Indexes (1)     sys.dm_exec_connections (1)    
sys.dm_db_partition_stats (7)     Aggregates (1)     Monitoring (1)     sys.dm_exec_cursors (1)    
tables (7)     Backup (1)     multi process (1)     sys.dm_tran_session_transactions (1)    
Arrays (5)     Backup / Restore (1)     next 13th (1)     sys.foreign_key_columns (1)    
Crosstab (5)     Barcode (1)     Nth occurance of day in a month/year (1)     sys.foreign_keys (1)    
Delimited Strings (5)     CLR functions (1)     Nth occurrence of a weekday in a month and year (1)     sys.sql_modules (1)    
List Indexes (5)     CLR Stored Procedures (1)     object (1)     System Tables (1)    
parse (5)     CLR UDT (1)     Object Permissions (1)     table field information (1)    
auto-growth (4)     Coalesce (1)     Parallel (1)     table metadata (1)    
data file management (4)     column description wi SQL (1)     Performance (1)     Table Valued Function (1)    
FOR XML PATH (4)     Column Permissions (1)     prime (1)     Temp tables (1)    
routine database growth (4)     Common Table Expression (CTE) (1)     prime number (1)     Tools (1)    
routine growth (4)     Data Warehousing (1)     Procedure (1)     TSQL (1)    
Security (4)     Databases (1)     PUBLIC (1)     UCC/EAN (1)    
Stored Procedures (4)     DateTime (1)     Puzzle (1)     URL (1)    
String Comparison (4)     DDL (1)     QA-Taskpad (1)     User (1)    
sys.allocation_units (4)     description (1)     Query Optimization (1)     XML (1)    
Administrator (3)     DM_DB_Index_Physical_Stats (1)     Referential Integrity (1)     Zip codes (1)    
Automation (3)     Drop Column (1)     report (1)    

Search for any content tagged T-SQL

Add a script

   Items 1 to 20 of 142    Next 20 >>
 

Wait for Mirror treshold

This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.  Read more...
By Wilfred van Dijk 2009/11/10 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 3 reads

Search in your T-SQL objects

This procedure searches for your criteria not only in code, but also in objectnames  Read more...
By Wilfred van Dijk 2009/11/16 | Source: SQLServerCentral.com | Category: Search
Rating: (not yet rated) |  Discuss |  Briefcase | 56 reads

Retrieve consecutive records from the table based the value difference

Retrieve consecutive records from the table based the value difference  Read more...
By Venkatesan Prabu Jayakantham 2009/11/04 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 386 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 516 reads

Kill Active connections

Simple Script to kill all active connection from current database.  Read more...
By SQL Species 2009/10/21 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 838 reads

Ultimate Alter Script generator

In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.  Read more...
By SQL Species 2009/10/30 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 527 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 600 reads

Aggregrating varchar columns

Concatenate columns grouping on Index column (approach for summing varchar columns by grouping on index)  Read more...
By Vikram Takrani 2009/09/22 | Source: SQLServerCentral.com | Category: Grouping VARCHAR Columns
Rating: (not yet rated) |  Discuss |  Briefcase | 413 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2009/09/16 | Source: SQLServerCentral.com | Category: SQL
Rating: |  Discuss |  Briefcase | 691 reads

Nth occurrence of a weekday in a month and year

To find date at nth occurrence of a weekday in a month and year  Read more...
By Rajneesh Kumar 2009/09/07 | Source: SQLServerCentral.com | Category: Nth occurrence of a weekday in a month and year
Rating: |  Discuss |  Briefcase | 470 reads

Execute T-SQL Scripts in Parallel

Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.  Read more...
By James Ma 2009/08/31 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,948 reads

What were the dates of all the Fridays in this quarter?

This script displays list of all dates of all Fridays of this quarter.  Read more...
By Ashka Modi 2009/08/25 | Source: SQLServerCentral.com | Category: DateTime
Rating: |  Discuss |  Briefcase | 669 reads

When will the next 13th fall on a Friday?

This example demonstrates how to use small part of complicated query structure.  Read more...
By Ashka Modi 2009/08/27 | Source: SQLServerCentral.com | Category: sql query
Rating: |  Discuss |  Briefcase | 425 reads

Nth occurence of a day in a month/year

This article gives a function which return a date based on its occurance as day for a particular month/year.  Read more...
By Biplov Dan 2009/08/21 | Source: SQLServerCentral.com | Category: Date Manipulation
Rating: |  Discuss |  Briefcase | 439 reads

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

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: Admin
Rating: (not yet rated) |  Discuss |  Briefcase | 1,157 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

CRUD generator

Script to generate create, read, update, and delete scripts for a table.   Read more...
By Ryan Foote 2009/07/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,229 reads

Using Coalesce in a stored Procedure

A quick way to take a column of data and place it into a variable in a Stored Procedure in a comma, separated format.  Read more...
By Richard Spalding 2009/06/26 | Source: SQLServerCentral.com | Category: Stored Procedures
Rating: |  Discuss |  Briefcase | 1,329 reads

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/19 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 349 reads
   Items 1 to 20 of 142    Next 20 >>
 
Most popular

Comparing Stored Procedures, Part 1

Provides quantifiable comparison of two stored procedures  Read more...
By Jesse McLain 2009/02/23 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 4,288 reads

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2009/03/26 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 4,043 reads

Execute T-SQL Scripts in Parallel

Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.  Read more...
By James Ma 2009/08/31 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,948 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use