Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 2005, SQL Server 7 Rss

<< Newer    Items 21 to 40 of 71    Older >>
 

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 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,770 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 Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,813 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,340 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-628038 2008/04/03 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 788 reads

SQL Server 2005 In-Place Upgrade Versions

By Key DBA 2008/03/28 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,297 reads

Open Source SQL DDL Scripting Tool

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.   Read more...
By Richard Sutherland 2007/03/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,412 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 5,055 reads

Set standard database options

Ensure all your databases have standardised options by running this script weekly.  Read more...
By Ed Vassie 2011/09/19 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 2,067 reads

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,411 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,878 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,881 reads

Check Instance Info

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.  Read more...
By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,414 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,412 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,311 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,500 reads

Replication Statement Delivery Options - Part 1

Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.   Read more...
By Andy Warren 2007/09/24 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,022 reads

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.   Read more...
By Additional Articles 2007/09/21 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,243 reads

Server Farm Reporting - Part 2

Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.   Read more...
By Mark Tierney 2007/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,794 reads

Using Non-Standard Port for SQL Server

Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.   Read more...
By Additional Articles 2007/08/03 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,797 reads

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.   Read more...
By Additional Articles 2007/07/06 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,384 reads
<< Newer    Items 21 to 40 of 71    Older >>
 
Tags
administration (26)    
security (6)    
t-sql (6)    
performance tuning (5)    
miscellaneous (4)    
monitoring (4)    
advanced querying (3)    
arrays (3)    
counter (3)    
delimited strings (3)    
development (3)    
news (3)    
nums (3)    
parse (3)    
sqlinsider scripts (3)    
strategies (3)    
string manipulation (3)    
table of numbers (3)    
tally (3)    
backup / restore (2)    
indexing (2)    
replication (2)    
sql server 2008 (2)    
best practices (1)    
database mail (1)    
database roles (1)    
databases (1)    
disaster recovery (dr) (1)    
dts (1)    
integration services (ssis) (1)    
jobs (1)    
logins (1)    
maintenance (1)    
metadata (1)    
naming standards (1)    
passwords (1)    
permissions (1)    
proxy accounts (1)    
random numbers (1)    
setup (1)    
sql agent (1)    
sql server 2000 (1)    
sql server 6.5 (1)    
sysobjects (1)    
table aliases (1)    
upgrading (1)    
writing readable code (1)    
xml (1)    
xp_sendmail (1)