Browse by Tags
All Tags »
SQL Server 2005 (
RSS)
PerformancePoint Planning does contain auditing out-of-the-box. However, it's not data level auditing but instead Metadata level auditing. If you want to track when a user has been added, or a workflow cycle started then PPS-P keeps a...
Andrew has posted a great list of community developed utilities for SQL Server . There is a few on there that have been on my 'must-do-one-day' list for far too long !
What seems like a lifetime ago I posted about MDX Stored Procedures and how we've built a helper class that provides a wrapper to an MDX query. The helper class has been stable for quite sometime now and a few people have been asking me when I'm...
You've been badgering away at a PerformancePoint Server Planning Model all day, updating objects, writing complex MDX scope statements to satisfy obscure business requirements and you've only got to add a new view to the time dimension before...
My job is pretty varied these days :o) Today I've been looking at satisfying some basket analysis type requirements where, for example, we need to determine what other products customers have bought in addition to a known product. We could have used...
UPDATE: You can find part 2 here , along with a link to download a C# quick start. A long time ago I realised that inevitably, however well specified the requirements or however tight the deadlines are, clients always throw a curve ball. To that avail...
I'm building a generic helper class to flatten an ADOMD data set to a data table for easier consumption by default and third party .NET controls. I can't rely on the Load method of the data table, nor the CellSet object as in some cases not all...
To get a realistic measurement of how your query tuning improves query response time you should start from a common point. To help with this you should clear your query cache before running a queries after making improvements (Unless you are cache warming...
Amongst some common, known hints there are a few new bits and pieces in this white paper: http://www.sqlserveranalysisservices.com/OLAPPapers/MDX%20Performance%20Hintsv1.htm
Microsoft has confirmed the processing of AS 2005 cubes from SSIS 2005 invoked from SQL Server Agent defaults to serial/sequential processing, irrespective of whether the parallel processing option has been selected. This results in increased cube processing...
If you attempt to script SQL 2005 objects and the database you want to script is missing from the list of databases, ensure the database compatibility level is not set to "SQL Server 7.0 (70)".