kumar1 (8/12/2011)

---

Hi All,

Do I need to wait all the way until the inside sp gets finished.

Can I get mainsp result fastly, as not holding to wait until the innersp done???

I...

If the execution plans are different, it means that SQL Server's optimizer decided (based on your predicate) to use a different way to get the results. That could be because...

NJ-DBA (8/11/2011)

---

Well, this might be silly to ask, but is the >=1 returning only a few records while the other options return many more records? i.e, is your first...

loki70 (4/4/2011)

---

I have a [SQL 2008] SSIS package that takes a CSV text file and moves it to a separate folder. Once it is in this folder, I import the...

Yuri55 (4/4/2011)

---

Just wondering how can we restrict some reports Export format list?

By default there are 6 possible Export formats but I would like to keep let say only 2

(Excel and...

Sumac (3/24/2011)

---

I'm looking for a good idea on the way to layout my fact table and still follow best practice. This looked like a good forum for that. Here's what...

Hi,

What you should be doing in this case, is to change your Question dimension to a type 2 SCD. By doing that you will be able to track the changes...

I guess the only question in my mind now is- should i stop using a table #B at all when i create the OLAP framework..since the primary purpose of table...

You can use CTE's in combination with Row_Number() function to achieve this.

For example:

with Image_CTE

as

(

select ...

, <row_number function>

from <table>

where image is not null

)

,

Signature_CTE

as

(

select ...

, <row_number function>

from <table>

where signature is not...

tmitchelar (11/5/2010)

From what I gathered in his post, the calculations only occur at the higher grain level, not the lowest. So he loses those calculations at the lower granularity....

Hi,

A good principle to follow when designing fact tables, is to always store the data at the more granular level. You can always aggregate up, but never down, and create...

I hate to say this...but it depends.

The general best practice would be to have a helper table, that contains the surrogate keys of both the fact and dimension...and a factor....

No, you shouldn't have an extra entry in the fact table...because there isn't another transaction for that amount and your numbers will double when aggregated.

There are a few ways to...

AmcAmx (8/11/2010)

---

Martin,

I got it working ! FINALLY !!! Here is what I had to do....

The variable that I created to store the...

Chris,

What about the Data Flow task itself. The screenshot I posted was the properties of the Data Flow Task, and not the Source Connection...

Another question: Does your OLEDB Source Connection...