SQL Server Central: Content tagged Administration, SQL Server 2005

SQL Server 2005 Service Accounts

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. Read more...

By Steve Jones 2008/07/11 (first posted: 2006/03/23) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 30,865 reads

The Differences Between SQL Server 2000 and 2005

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. Read more...

By Steve Jones 2007/08/31 (first posted: 2007/05/15) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 66,227 reads

Upgrading a Database SQL 2000 to SQL 2005

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. Read more...

By Sachin Samuel 2007/05/16 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 30,964 reads

DAC Port

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 | 763 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 7 for SP2. Read more...

By Steve Jones 2008/04/23 (first posted: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 44,205 reads

Backups

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,894 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 7 for SP2. Read more...

By Steve Jones 2008/04/23 (first posted: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 44,205 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,486 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

Find blocking processes using recursion in SQL Server 2005

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. Read more...

By Additional Articles 2008/04/03 | Source: Builder.com | Category: SQL Server 2005

Rating: (not yet rated) Rate this |

Briefcase | 1,891 reads

Write your own sp_lock system stored procedure in SQL Server 2005

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. Read more...

By Additional Articles 2008/03/31 | Source: Builder.com | Category: SQL Server 2005

Rating:

Rate this |

Briefcase | 1,820 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 7 for SP2. Read more...

By Steve Jones 2008/04/23 (first posted: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 44,205 reads

Moving System Databases

Dynamic Management Views and Functions in SQL Server 2005

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. Read more...

By S. Srivathsani 2007/04/23 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 9,128 reads

SQL Server 2005 Best Practices

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. Read more...

By Nanda Kishore 2008/03/14 (first posted: 2006/01/04) | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 96,320 reads

Reporting Services Makes Server Support Easier

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 Read more...

By Carolyn Richardson 2007/03/12 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 7,259 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: Administering

Rating:

|

Discuss |

Briefcase | 7,503 reads

New Isolation Levels Available in SQL Server 2005

One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced. Read more...

By Additional Articles 2007/03/05 | Source: SQL Server Performance | Category: Administration

Rating:

Rate this |

Briefcase | 3,091 reads

Content with tags Administration, SQL Server 2005

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