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 SQL Server 2005 Rss

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

T-SQL (39)     2-Dimensional Arrays (2)     Data Types (1)     Procedure (1)    
Administration (37)     auto-growth (2)     Database Files (1)     Puzzle (1)    
Maintenance and Management (27)     Backup (2)     database options administration (1)     Queries (1)    
T-SQL Aids (25)     Backup / Restore (2)     Database Roles (1)     quotename (1)    
Utility (21)     BCP (2)     database size (1)     Random Numbers (1)    
Maintenance (20)     Buffer Cache (2)     DBCC (1)     Reindex (1)    
SQL Server 7, 2000 (15)     data file management (2)     DDL Triggers (1)     Restore (1)    
Index Management (14)     Fragmentation (2)     Defragment (1)     Running aggregate (1)    
Indexes (13)     games (2)     Dependencies (1)     Running Totals (1)    
Miscellaneous (13)     Index Usage (2)     DM_DB_Index_Physical_Stats (1)     Schema (1)    
Indexing (11)     Jobs (2)     DROP (1)     script (1)    
Performance Tuning (11)     Linked Server (2)     dump (1)     Selectivity (1)    
Advanced Querying (8)     Lock and Connection Management (2)     Duplicate Indexes (1)     setup (1)    
Development (8)     Monitoring (2)     dynamic (1)     shrink (1)    
Search (8)     report (2)     ETL (1)     Shrink Database (1)    
Admin (7)     routine database growth (2)     Files and Filegroups (1)     sieve (1)    
nums (7)     routine growth (2)     Foreign Key (1)     Size estimation (1)    
SQLInsider Scripts (7)     SQL Agent (2)     foreign key constraints (1)     sp_msforeachdb (1)    
sys.dm_db_partition_stats (7)     sys.dm_exec_query_plan (2)     foreign keys (1)     sp_spaceused (1)    
Table of Numbers (7)     sys.dm_exec_requests (2)     Growth (1)     SQL Server 2000 (1)    
tables (7)     sys.dm_exec_sessions (2)     growth trend (1)     status (1)    
tally (7)     sys.dm_exec_sql_text (2)     index maintenance (1)     sybase linked server (1)    
counter (6)     sys.dm_os_buffer_descriptors (2)     Index Tuning (1)     sys.columns (1)    
parse (6)     sys.partitions (2)     Indexed Views (1)     sys.dm_db_index_usage_stats (1)    
pivot (6)     Sysobjects (2)     Information (1)     sys.dm_db_missing_index_details (1)    
Storage (6)     Troubleshooting (2)     Integration Services (SSIS) (1)     sys.dm_exec_connections (1)    
Arrays (5)     Aggregates (1)     like (1)     sys.dm_exec_cursors (1)    
automated DBA (5)     ASCII (1)     Log directory (1)     sys.dm_tran_session_transactions (1)    
Crosstab (5)     automatic (1)     log file (1)     sys.foreign_key_columns (1)    
Delimited Strings (5)     Backup directory (1)     Log path (1)     sys.foreign_keys (1)    
List Indexes (5)     Backup path (1)     Logins (1)     sys.sql_modules (1)    
Security (5)     bulk insert (1)     Metadata (1)     sys.systypes (1)    
String Manipulation (5)     CLR functions (1)     Missing Indexes (1)     sys.tables (1)    
FOR XML PATH (4)     CLR Stored Procedures (1)     parameters (1)     syscolumns (1)    
index (4)     CLR UDT (1)     Partitioning (1)     Table (1)    
Management (4)     Clustering (1)     Passwords (1)     Table search (1)    
sys.allocation_units (4)     column (1)     Performance (1)     TSQL (1)    
Space Usage (3)     columns (1)     Permissions (1)     whitespace (1)    
SQL Server 2008 (3)     Data directory (1)     prime (1)     XML (1)    
Stored Procedures (3)     Data path (1)     prime number (1)    

Search for any content tagged SQL Server 2005

Add a script

   Items 1 to 20 of 104    Next 20 >>
 

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 | 17 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files  Read more...
By Luan Moreno M. Maciel 2009/11/03 | Source: SQLServerCentral.com | Category: ETL
Rating: |  Discuss |  Briefcase | 998 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 | 571 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 | 631 reads

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table  Read more...
By Samardeep Khera 2009/08/12 | Source: SQLServerCentral.com | Category: Stored Procedures
Rating: |  Discuss |  Briefcase | 1,028 reads

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005  Read more...
By Sandesh Segu 2009/08/04 | Source: SQLServerCentral.com | Category: Table search
Rating: |  Discuss |  Briefcase | 705 reads

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns, indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.  Read more...
By Lowell Izaguirre | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 80 reads

Sybase linked server in sql 2005

How to create and configure Sybase linked server in SQL Server 2005  Read more...
By umar iqbal 2009/07/21 | Source: SQLServerCentral.com | Category: Linked Server
Rating: |  Discuss |  Briefcase | 282 reads

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-396570 2009/07/17 | Source: SQLServerCentral.com | Category: Indexes
Rating: |  Discuss |  Briefcase | 439 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,220 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 | 824 reads

The Automated DBA: Batch Database File Grower - SQL2005 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/22 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 528 reads

The Automated DBA: Batch Database File Grower - SQL 2005 Version

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/23 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 582 reads

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.  Read more...
By Jesse Roberge 2009/06/15 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 680 reads

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2009/06/17 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,129 reads

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...
By Jesse Roberge 2009/05/29 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 608 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,486 reads

Table size estimation (MS SQL 2005)

Procedure to estimate table size in accordance with http://msdn.microsoft.com/en-us/library/ms187445(SQL.90).aspx  Read more...
By Igor Nikitin 2009/05/20 | Source: SQLServerCentral.com | Category: Size estimation
Rating: |  Discuss |  Briefcase | 958 reads

usp_PartitionDatabase

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...
By Pedro Lopes-389536 2009/05/12 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 633 reads

Cluster Information

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources  Read more...
By Rudy Panigas 2009/05/08 | Source: SQLServerCentral.com | Category: Clustering
Rating: |  Discuss |  Briefcase | 501 reads
   Items 1 to 20 of 104    Next 20 >>
 
Most popular

SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 23,019 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2008/10/06 | Source: SQLServerCentral.com | Category: Index Management
Rating: |  Discuss |  Briefcase | 10,988 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,486 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use