http://www.sqlservercentral.com/Content tagged Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/2007/07/13http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/Delete files on a fileshare leaving behind files not older than n-days.http://www.sqlservercentral.com/scripts/Administration/62729/2008/04/02http://www.sqlservercentral.com/scripts/Administration/62729/sp_depends may not always return accurate informationhttp://www.sqlservercentral.com/scripts/Administration/62801/2008/04/10http://www.sqlservercentral.com/scripts/Administration/62801/Will list Table Name, Constraint name and Primary Key Column Namehttp://www.sqlservercentral.com/scripts/Normalization/62620/2008/05/16http://www.sqlservercentral.com/scripts/Normalization/62620/SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.http://www.sqlservercentral.com/articles/Administration/62930/2008/05/12http://www.sqlservercentral.com/articles/Administration/62930/http://www.sqlservercentral.com/questions/Administration/62777/2008/05/09http://www.sqlservercentral.com/questions/Administration/62777/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/This query gives you an idea of the growth of your database over time.http://www.sqlservercentral.com/scripts/Backup/62497/2008/05/07http://www.sqlservercentral.com/scripts/Backup/62497/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/http://www.sqlservercentral.com/questions/SQL+Server+2005+Express/62651/2008/04/24http://www.sqlservercentral.com/questions/SQL+Server+2005+Express/62651/Build List Updated with Cumulative Update 7 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/04/23http://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/http://www.sqlservercentral.com/questions/Administration/62595/2008/04/16http://www.sqlservercentral.com/questions/Administration/62595/Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005. http://www.sqlservercentral.com/articles/Administration/2967/2008/04/16http://www.sqlservercentral.com/articles/Administration/2967/An interesting script to handle file tasks from within SQL Server.http://www.sqlservercentral.com/redirect/articles/62711/2008/04/16http://www.sqlservercentral.com/redirect/articles/62711/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/It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances.http://www.sqlservercentral.com/redirect/articles/62710/2008/04/14http://www.sqlservercentral.com/redirect/articles/62710/http://www.sqlservercentral.com/questions/Administration/62648/2008/04/11http://www.sqlservercentral.com/questions/Administration/62648/Build List Updated with Cumulative Update 7 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/04/23http://www.sqlservercentral.com/articles/Administration/2960/Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database http://www.sqlservercentral.com/scripts/String+Manipulation/62203/2008/04/11http://www.sqlservercentral.com/scripts/String+Manipulation/62203/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/List tables that have different tables and column http://www.sqlservercentral.com/scripts/Administration/62276/2008/04/07http://www.sqlservercentral.com/scripts/Administration/62276/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/RDL for use in MSSSQL 2005's Management Studio (custom reports). http://www.sqlservercentral.com/scripts/SQL+2005/62013/2008/03/28http://www.sqlservercentral.com/scripts/SQL+2005/62013/ever want to allow people to execute jobs bot not be admins?http://www.sqlservercentral.com/articles/Jobs/62374/2008/03/27http://www.sqlservercentral.com/articles/Jobs/62374/Build List Updated with Cumulative Update 7 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/04/23http://www.sqlservercentral.com/articles/Administration/2960/