What do you think?
At the December meeting of SLODUG, the Slovenian Developers User Group, I've presented two new functionalities introduced with SQL Server 2008:
WHEREclause to the definition of indexes (and statistics) on base tables restrictions can be applied to data sets being indexed, thus introducing several new possibilities, such as:
More on these two subjects (and why they actually represent the same one) is available in the presentation. Clue: Rational Flexibility.
(Or rather the files *will be* available as soon as they've been uploaded to the SLODUG site.)
This may be old news, but I haven't said anything about this so far, so this may not be old news to everyone. ;)
SQL Server 2005 SP3 has been released on December 15th 2008. The files (elevating the full version number to 9.00.4035) are available for download:
Before applying SP3 you should be aware of the fact that not all Cumulative Updates (CU) for SQL Server 2005 are included in SP3. More information is available in MSDN Knowledge Base article #959195: Cumulative update package 1 for SQL Server 2005 Service Pack 3.
The feature pack for SQL Server 2005 has also been updated:
The local install version of SQL Server 2005 Books Online has also been updated on December 16th 2008. The files are available for download: