Simon Worth’s SQL Server Weblog

SQL Server and its many complexities

Archive for the ‘SQL Server Storage Engine’ Category

Tableau 6.0 What If Modeling

with one comment

Tableau 6 has introduced what if modeling using parameters.  Click the link here to see a short 5 minute demo of the product in action.  It’s these little enhancements to the product that set Tableau ahead of the pack when it comes to data visualization and analysis. 


Written by Simon Worth

October 15, 2010 at 8:31 am

ProClarity Analytics Server Hotfix Available

leave a comment »

A new hotfix rollup package is available to fix a few issues with PAS 6.3.  Here is the link to the downloads page (by request for download).

From the website

Issues that this hotfix rollup package fixes

This hotfix rollup package fixes the following issue:
After you install ProClarity Analytics Server 6.3 Service Pack 3, you may experience one or more of the following symptoms:

  • Internet Explorer stops responding when you try to access the home page of ProClarity Analytics Server.
  • You receive a "Catastrophic failure" error message when you click the My Views menu in ProClarity Web Professional.
  • You cannot start ProClarity Web Professional. Specifically, ProClarity Web Professional stops responding during the starting process.

Written by Simon Worth

October 15, 2010 at 8:02 am

SQL Server 2008 Service Pack 2

leave a comment »

The team at Microsoft have released Service Pack 2 for SQL Server 2008.  The big enhancement from this SP for me is Reporting Services integration with SharePoint 2010. 

The link to the Service pack is here.  As always, test any new service packs before promoting to a production environment – and have fun.

The list of new features are as follows (directly from the Service Pack page)

  • 15K partitioning Improvement. Introduced support for a maximum of 15,000 partitions in tables and indexes in Microsoft SQL Server 2008 Service Pack 2 in the Enterprise, Developer and Evaluation Editions. For details on how this support can be enabled and disabled, along with recommended operation paramaters, see the white paper Support for 15000 Partitions.
  • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What’s New (Reporting Services).
  • SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
  • SQL Server 2008 Instance Management.With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. For more information, seeOverview of SQL Server Utility in SQL Server 2008 R2 Books Online.
  • Data-tier Application (DAC) Support.Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

Written by Simon Worth

September 29, 2010 at 12:59 pm

SQL Server 2008 SP1 Cumulative Update 9 Now Available

leave a comment »

Microsoft has released cumulative update 9 for SQL Server 2008 SP1.  The link to the details page can be found here.  As with most cumulative updates, Microsoft does warn against installing these packages unless you are experiencing specific issues that are addressed in the update.  SP2 will contain all cumulative updates after SP1 – so if you don’t need any of the specific fixes then it is probably best to wait for the next service pack to be released.

A few of the fixes include

  • Error message when you run a SQL Server 2005 or SQL Server 2008 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
  • Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer
  • A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008
  • A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format
  • Blank spaces between some items are generated incorrectly in a SQL Server 2008 report
  • "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008
  • A query returns inconsistent results before the data cache is warmed up in SSAS 2008

These are just a few of the fixes, visit the website for more information on all issues resolved and to get further details on how to download the updates if required.

Written by Simon Worth

July 22, 2010 at 8:28 am

Microsoft SQL Server 2008 SP2 CTP Available

leave a comment »

Microsoft has released the Community Technology Preview for SQL Server 2008 Service Pack 2.  The CTP can be downloaded from this link.  This is CTP only and should not be deployed to a production environment.  Service Pack 2 contains all the cumulative updates released after SQL Server 2008 SP1.

Service pack 2 includes

  • Compatibility for the SQL Server 2008 R2 Server Utility.  2008 SP2 servers are supported by the utility and contain the same functionality as R2 servers.
  • SQL Server 2008 R2 Supports DAC operations for SQL Server 2008 SP2
  • Reporting Services Add-in for SharePoint 2007

Written by Simon Worth

July 9, 2010 at 10:09 am

Whitepaper About Star Join Optimizations

leave a comment »

Microsoft SQL Server Development Customer Advisory Team

via Whitepaper About Star Join Optimizations.

Written by Simon Worth

December 18, 2009 at 10:34 am

ProClarity Install Prerequisites – PTS for SQL Server 2005

leave a comment »

From The Microsoft ProClarity Team Blog ProClarity Install Prerequisites – PTS for SQL Server 2005.

Written by Simon Worth

December 5, 2009 at 10:49 am