SolidQ Journal

There is a new monthly SQL Server reading material for free at http://www.solidq.com/sqj
So take a look and have a nice day,

CU
tosc

SQL Server 2008 SP2 CTP

At SQL Server Team Blog:  SQL Server 2008 SP2 CTP is now available for public testing

The CTP version of SQL Server 2008 Service Pack 2 (SP2) contains the cumulative updates up to SQL Server 2008 SP1 cumulative update package 8. Upgrade only for the following SQL Server 2008 editions:

  • Enterprise
  • Standard
  • Evaluation
  • Developer
  • Workgroup

Download: Download SQL Server 2008 SP2 CTP

And for Express Edition or Express Edition with Advanced Services: SQL Server 2008 Express Edition Service Pack 2 – CTP

CU
tosc

How To Stay Current with SQL Server Cumulative Updates

#CU package 2 for SQL Server 2008 R2

The Cumulative update package 2 for SQL Server 2008 R2 (Build 10.50.1720.0) is available:

http://support.microsoft.com/kb/2072493/

And here you can get the whole information of builds that were released after SQL Server 2008 R2 was released:

http://support.microsoft.com/kb/981356/

CU
tosc

#CU package 10 for SQL Server 2005 SP3

The Cumulative update package 10 for SQL Server 2005 SP3  (Build 9.00.4305 ) is available:

http://support.microsoft.com/kb/983329/

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released: http://support.microsoft.com/kb/960598/

CU
tosc

Analysis and Reporting Services, Design and Implementation

Technical Note: SQL Azure Database Client

Backup, Integrity Check and Index Optimization

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)

He made some updates to the maintenance scripts:

  • Changed behaviour in the job that deletes old output files. The old version returned an error if there was no files to delete. This has been changed not to return an error.
  • Bug fix: Collation conflict when creating the objects in a database with a collation other than the collation in tempdb.
  • Changed default for backup compression. In the new version the backup compression default in sys.configurations is used in SQL Server 2008 Enterprise Edition and in SQL Server 2008 R2 Standard, Enterprise and Datacenter Edition. In SQL Server versions and editions where backup compression is not supported the default is 'N'.
  • New job for purging job history. It's using the stored procedure sp_purge_jobhistory
  • New job for purging backup history. It's using the stored procedure sp_delete_backuphistory
  • New job for deleting output files
  • If you have an index with page locking disabled and you rebuild it online using multiple CPUs, the fragmentation will in some cases not go away. This is a bug in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. I have made a workaround in IndexOptimize setting MAXDOP = 1, when you rebuild an index online that has page locking disabled
  • Now backup compression is supported also in Standard Edition

CU
tosc

Glorf-IT: SQL-PASS-Wunschliste für Franken

Rebuilding system databases in 2008 R2