SQL Server 2008: First look Preview - The Diigo Meta page

• 14 Aug 08
  

  Adam Willoughby

  mssql sqlserver Database

• 07 Jul 08
  

  Mr. DiGi

  mssql 2008 benchmark database

  • Users will notice a completely overhauled reporting engine and greatly improved OLAP performance. This should allow more users to run OLAP queries, or enable existing OLAP users to run more complex queries than are currently possible.
  • Another groundbreaking addition is SQL 2008’s FileStream data type. These records can contain arbitrary data — such as text, sound or video — and can be searched using normal database commands. The difference is that FileStream records are stored on the local NTFS filesystem, which means they can contain much more data than a normal SQL record, and performance can be better too.
  • Microsoft claims SQL Server 2008 will run 14 per cent faster than SQL Server 2005 on a quad-socket server
  • Database mirrors have been improved in order to store null values more efficiently, and the logs that synchronise database mirrors can now be compressed. This should reduce the amount of bandwidth needed to maintain duplicates of a database. Finally, a new resource governor enables administrators to assign CPU power to particular applications.

  2 more annotations...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.