I'm no hardware expert, but in this case it wouldn't matter since you have all disks in the array. Being in RAID 5, all your data is striped across all...

Yes, with "SQL Binaries" they probably mean the installation files and folders.

IMHO I don't think it is as much a performance issue. I suppose the spindles could work overtime if...

The above is your problem. By default, Reporting Services will take all the selected values from the multi-select dropdown and concatenate them. If you pass this into a stored...

Excellent analogy 🙂

The only other suggestion I could add over and above what was already said, is to do as little formatting as possible.

Make all your destination columns varchar...you rather want...

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....