Find Current Location of Data and Log File of All the Database

SELECT name, physical_name AS current_file_location

FROM sys.master_files

Cumulative update package 1 for SQL Server 2005 Service Pack 3

Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 3 hotfix to an installation of SQL Server 2005 Service Pack 3. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.

Cumulative Update 1 for SQL Server 2005 Service Pack 3 (SP3) contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 (SP2) and Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2). These hotfixes are not included in SQL Server 2005 Service Pack 3. Cumulative Update 1 for SQL 2005 SP3 is only intended as a post-service pack rollup for Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2 customers who plan to upgrade to SQL Server 2005 SP3 and still keep the hotfixes from Cumulative Update 10 for SQL Server 2005 SP2 and Cumulative Update 11 for SQL Server 2005 SP2. No new hotfixes have been included in this cumulative update other than the hotfixes that were already released in Cumulative Update 10 and Cumulative Update 11.

http://support.microsoft.com/default.aspx/kb/959195

How to move a SQL Server database within the same instance without losing settings

Problem:

I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?

Solution:

http://www.mssqltips.com/tip.asp?tip=1688

Microsoft SQL Server 2008 Books Online (January 2009)

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information:
Setup and upgrade instructions.
Information about new features and backward compatibility.
Conceptual descriptions of the technologies and features in SQL Server 2008.
Procedural topics describing how to use the various features in SQL Server 2008.
Tutorials that guide you through common tasks.
Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server 2008.
Descriptions of the sample databases and applications that are available with SQL Server 2008. You can download the sample databases from the SQL Server Community Projects and Samples page on CodePlex.

http://www.microsoft.com/downloads/details.aspx?FamilyId=765433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en

SQL Server 2008 System Views Map

מייקרוסופט שיחררה SQL Server 2008 System Views Map:

The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them. The map is similar to the Microsoft SQL Server 2005 version and includes updates for the new and updated the Microsoft SQL Server 2008 features such as resource governor, extended events, full-text search, and others.

http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en#filelist