SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tag SQL Server 2005 Rss

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

Miscellaneous (10)     games (2)     index (1)     query (1)    
Administration (6)     T-SQL Aids (2)     Indexes (1)     report (1)    
SQL Server 2000 (5)     Advanced Querying (1)     Indexing (1)     SQL 2005 (1)    
T-SQL (5)     Backup (1)     Maintenance (1)     Storage (1)    
Index Management (4)     Backup / Restore (1)     Permissions (1)     tables (1)    
Maintenance and Management (4)     DDL Triggers. (1)     Puzzle (1)     TSQL (1)    
Management (3)     dump (1)    

Search for any content tagged SQL Server 2005

Add a script

   Items 1 to 20 of 28    Next 20 >>
 

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 18 reads

SQL 2005 IndexDefrag solution

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night  Read more...
By Kobus 2008/06/19 | Source: SQLServerCentral.com | Category: Indexing
Rating: (not yet rated) |  Discuss |  Briefcase | 33 reads

A Sudoku solution with set based T-SQL utilizing binary operators.

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2008/06/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 103 reads

SQL Server 2005 Index Maintenance

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...
By Luke C 2008/05/29 | Source: SQLServerCentral.com | Category: Maintenance
Rating: |  Discuss |  Briefcase | 93 reads

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 2008/04/29 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 773 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database.  Read more...
By RBarryYoung 2008/04/08 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |  Briefcase | 1,500 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,263 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By adam haines 2008/03/11 | Source: SQLServerCentral.com | Category: TSQL
Rating: |  Discuss |  Briefcase | 967 reads

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 2,920 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By Carley Zepeda 2008/04/17 | Source: SQLServerCentral.com | Category: Permissions
Rating: |  Discuss |  Briefcase | 809 reads

Available bytes for row expansion (adding columns) in a table

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...
By ruchir 2008/04/03 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 339 reads

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE  Read more...
By Rafal S. 2008/03/31 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: (not yet rated) |  Discuss |  Briefcase | 541 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal S. 2008/04/14 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,246 reads

Search for a text in all databases

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.  Read more...
By Rafal S. 2008/03/12 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 813 reads

Search for a specified GUID (or its part) in all databases (updated)

This procedure searches for the specified GUID (or its part) in all (or selected one) databases  Read more...
By Rafal S. 2008/03/06 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 411 reads

Sorted views in 2005 and TOP clause

These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.  Read more...
By Rafal S. 2008/02/22 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 631 reads

Generating combinations 'm elements from n-element set'

This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.   Read more...
By Rafal S. 2008/04/01 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 306 reads

Generating permutations

This script shows one on ways of generating permutations.  Read more...
By Rafal S. 2008/02/27 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 498 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object  Read more...
By Jesse McLain 2008/02/26 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 791 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2008/02/11 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 5,815 reads
   Items 1 to 20 of 28    Next 20 >>
 
Most popular

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2008/02/11 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 5,815 reads

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 2,920 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2008/01/17 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 2,506 reads