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

Search for any content tagged T-SQL

   Items 1 to 20 of 145    Next 20 >>
 

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.  Read more...
By Bernabe Diaz 2009/12/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 18 reads

syscolumns names

get a list of syscolumns names from string comma separated columns list  Read more...
By Bernabe Diaz 2009/12/02 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 6 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 28 reads

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 | 174 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: |  Discuss |  Briefcase | 605 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 | 429 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 | 581 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 | 871 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 | 573 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 | 634 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 | 427 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 | 721 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 | 482 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 | 2,214 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 | 692 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 | 432 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 | 444 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 | 614 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,229 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 | 832 reads
   Items 1 to 20 of 145    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,475 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 | 2,214 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,301 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use