SQLServerCentral.com Content tagged SQL Server 2005

SSIS Synchronize Remote FTP Directory

Fri, 17 May 2013 06:00:00 UT

Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.

Generate a random password

Wed, 15 May 2013 06:00:00 UT

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

The Ultimate Missing Index Finder

Mon, 07 Jan 2013 07:00:00 UT

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.

Generate Drop / Create Script for views, stored Procedures

Tue, 01 Jan 2013 07:00:00 UT

This Script generates drop and create scripts for views or stored procedures.

Table Information View -- No Cursors!

Fri, 28 Dec 2012 07:00:00 UT

Row counts and storage space information for all tables in the database. (SQL Server 2005).

The Ultimate Index Usage Reporter

Thu, 27 Dec 2012 07:00:00 UT

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.

Get record count for a specific database

Wed, 26 Dec 2012 07:00:00 UT

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

Drop FK For A Specific Table

Tue, 04 Sep 2012 06:00:00 UT

Drop FK For A Sprecific Table

2008 Index Rebuild using DMV

Thu, 09 Aug 2012 06:00:00 UT

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.

Create_sp_help_revlogin_DB

Wed, 01 Aug 2012 06:00:00 UT

Enhanced sp_help_revlogin

2005 Online Index Rebuild using DMV

Tue, 31 Jul 2012 06:00:00 UT

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.

Using DDL Trigger

Tue, 17 Jul 2012 06:00:00 UT

Using DDL Triggers

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

Three Attack Vectors in SQL Server 2005

Wed, 07 Mar 2012 07:00:00 UT

This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.

Server-Side Trace Pack

Fri, 02 Mar 2012 07:00:00 UT

Loads temporary stored procs that assist in running and monitoring server-side tracing.

sp_JobSchedule_rpt for SQL 2005/8

Thu, 23 Feb 2012 07:00:00 UT

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

create jobs script for 2000 2005 or 2008

Wed, 18 Jan 2012 07:00:00 UT

will create jobs script for backup or DR purposes to install on another server.

Understanding and Using APPLY (Part 2)

Fri, 13 Jan 2012 07:00:00 UT

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.

Understanding and Using APPLY (Part 1)

Fri, 06 Jan 2012 07:00:00 UT

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Logins created in the last X Days

Fri, 23 Dec 2011 07:00:00 UT

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.

Comprehensive Backup Script

Thu, 22 Dec 2011 07:00:00 UT

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.

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

Wed, 21 Dec 2011 07:00:00 UT

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.

Monitor Any Linked Server From SQL 2005

Mon, 19 Dec 2011 07:00:00 UT

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005

Check Instance Info

Thu, 15 Dec 2011 07:00:00 UT

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Report SQL SERVER 2005 Permissions

Mon, 12 Dec 2011 07:00:00 UT

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.

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

Fri, 09 Dec 2011 07:00:00 UT

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

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.