Igor Micev (2/26/2013)

---

I want to enable trace flag 2371 for update statistics.

The application generates a lot of queries. As enabling the trace flag withdraws recompilation of the queries, is this...

I just took a look at one of my SSIS packages that contains the Analysis Services Processing Task. I just have my processing settings to 'Process Full'; there's not...

Jason Marshall (1/17/2014)

---

Good morning-

I have an SSIS package that calls an Analysis Services DDL task to do a full process of our cube as part of our batch ETL. ...

The good ol' MessageBox still works in a script task; not very elegant, but better than nothing.

Rob

I hope they do it better the embarrassing travesty that is NFL replay.

Rob

sharonsql2013 (1/9/2014)

---

I need to display the following data but I want to for two seperate dates..

One for the current month and another for last 3 months.

SELECT

Category ,

Sub_Category,

...

We've run into a lot of browser compatibility issues lately with the newest browsers -- it's almost like the bad old days of the Mozillia Netscape / Microsoft IE wars....

How many packages do you need to downgrade? If the number is small enough, tour best bet may be just to recreate these in VS/BIDs 2008 R2. I...

Why not just create a report? When I look at your attached picture, it looks like a straight-forward report to me.

Rob

What are your page length and page width settings?

For a more detailed explanation take a look at: http://msdn.microsoft.com/en-us/library/dd255278.aspx

HTH,

Rob

Lempster (12/18/2013)

---

Sounds very strange!

Is your source query just a 'standard' SQL command or is it derived from a variable and/or expression? Is the SSIS package running as a...

ard5karthick (12/3/2013)

---

There are two Cube Databases in the same server with identical schema.

In than we have created a ProjectID dimension on an Unique identifier (GUID) Column...

When i execute an MDX...

harita (12/4/2013)

---

I am new to ssis and I want some info on how to create a ssis package here is the scenario.

server a ...

Eric Mamet (12/5/2013)

---

Like many, we built a data warehouse (datamart?) and a set of cubes and we'd like our users to be able to query the database themselves through...

SELECT e.ID,

COALESCE(e.ParentEstimateId, e.ID) AS EstimateNumber,

CAST(ROW_NUMBER() OVER (PARTITION BY COALESCE(e.ParentEstimateId, e.ID) ORDER BY COALESCE(e.ParentEstimateId, e.ID), e.ID) AS int) AS RowNumber

FROM dbo.Estimate...