SQL Server 2008 R2 Service Pack 1

Service Pack 1 for SQL Server 2008 R2 has been recently released and available to download for SQL Server customers / users. You can download the Service Pack from http://www.microsoft.com/download/en/details.aspx?id=26727.

There are certain enhancements for SQL Server 2008 R2 product along with fixing a lot of known bugs in the RTM. The Service pack is released in all 3 major hardware platforms (X86,X64 and Ia64) and it is applicable for almost all Editions of SQL Servers.

For a list of known bugs that are addressed in the Service Pack 1, refer this knowledge base article http://support.microsoft.com/kb/2528583

As always whenever a service pack is applied on a mission critical system, it is suggested practice that you test the service pack thoroughly in a test environment.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty

List of all Data and Log Files of a SQL Instance

Ever faced a sitaution where you had to find out all the database files (Data and Log) of a SQL Instance?

I came across this situaion many times, especially when I am working with a new SQL Instance which was taken over by my team OR when the previous admin of that box has left the company and its now my turn to maintain / administer that instance.

In order to list the files, we just need to query the system table sysaltfiles.  The picture below is a screen show that I ran earlier today on one of my SQL Instances.

SELECT * FROM SYSALTFILES

This  query can be further tweaked to get only the data files or only the log files by adding where clause and filter by griupid column. Groupid = 1 indicates it is a data file and groupid = 0 indicates it is a log file.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty