http://www.sqlservercentral.com/Content tagged SQL Server 2005, Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/Searches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.http://www.sqlservercentral.com/scripts/Administration/63401/2008/06/08http://www.sqlservercentral.com/scripts/Administration/63401/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/63164/2008/07/16http://www.sqlservercentral.com/scripts/Administration/63164/Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005. http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/2008/07/11http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/Returns list of active processes and their buffer contents over a specified time.http://www.sqlservercentral.com/scripts/Administration/63169/2008/07/02http://www.sqlservercentral.com/scripts/Administration/63169/http://www.sqlservercentral.com/questions/Administration/63290/2008/07/02http://www.sqlservercentral.com/questions/Administration/63290/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63173/2008/06/30http://www.sqlservercentral.com/scripts/Administration/63173/This article describes how to generate the sp_who2 results including the query text for the spid.http://www.sqlservercentral.com/articles/Administration/63144/2008/06/26http://www.sqlservercentral.com/articles/Administration/63144/Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences. http://www.sqlservercentral.com/articles/Administration/2988/2008/05/08http://www.sqlservercentral.com/articles/Administration/2988/Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade. http://www.sqlservercentral.com/articles/Administration/2987/2008/05/07http://www.sqlservercentral.com/articles/Administration/2987/http://www.sqlservercentral.com/questions/SQL+Server+2005/62652/2008/04/30http://www.sqlservercentral.com/questions/SQL+Server+2005/62652/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.http://www.sqlservercentral.com/scripts/Administration/62598/2008/04/29http://www.sqlservercentral.com/scripts/Administration/62598/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/http://www.sqlservercentral.com/questions/Backup+and+Recovery/62649/2008/04/21http://www.sqlservercentral.com/questions/Backup+and+Recovery/62649/Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/2008/04/15http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/Row counts and storage space information for all tables in the database.http://www.sqlservercentral.com/scripts/tables/62545/2008/04/08http://www.sqlservercentral.com/scripts/tables/62545/This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns. http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/2008/04/03http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work.http://www.sqlservercentral.com/redirect/articles/62558/2008/04/03http://www.sqlservercentral.com/redirect/articles/62558/The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions.http://www.sqlservercentral.com/redirect/articles/62557/2008/03/31http://www.sqlservercentral.com/redirect/articles/62557/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/http://www.sqlservercentral.com/questions/Administration/62318/2008/03/21http://www.sqlservercentral.com/questions/Administration/62318/DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use. http://www.sqlservercentral.com/articles/Administration/2928/2008/03/18http://www.sqlservercentral.com/articles/Administration/2928/With SQL Server 2005 recently released, one of the things that many people are looking for are some guidelines for working with the new product. New author Nanda Kishore brings us a list of best practices that should give you a start. http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/2008/03/14http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers http://www.sqlservercentral.com/articles/Administration/2898/2008/03/04http://www.sqlservercentral.com/articles/Administration/2898/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. http://www.sqlservercentral.com/articles/Administering/2896/2008/03/03http://www.sqlservercentral.com/articles/Administering/2896/