Igor Micev (3/14/2014)

---

80+ filegroups is too much for that size of a database.

80+ files is also a big number, but it's more normal for files.

There are benefits of having multiple...

Database was ~250GB but then was sized up to 750GB to avoid auto-grow so there is a ton of free space in there.

All files reside on a single RAID10 volume....

Thanks for all the responses guys. We were actually planning an app upgrade to follow the OS and SQL upgrade but after reviewing the vendor docs it looks like this...

Great article.

imz (6/13/2013)

---

RonKyle (6/13/2013)

---

You can actually simplify it even more if you like, by using a File System Task, instead of a Script Task to move your processed files once done....

I just wanted to say thanks to the OP. I've been using SSRS with t-sql for years but SSAS/MDX are new to me. This really helps!:w00t:

Mackers (2/8/2013)

---

Hi,

That's fine if you are writing all the MDX yourself but not ideal if you are using an ad-hoc query tool (like pivot tables in Excel or ProClarity or...

msmithson (1/31/2013)

---

I'm new to SSAS so bear with me.

I have a calculated measure based on an attribute in one of my dimensions. The calculation looks like this:

CREATE MEMBER CURRENTCUBE.[Measures].[Office Visits]

...

jasona.work (1/21/2013)

---

Michael L John (1/21/2013)

---

I just bought a Subaru Outback 2 months ago. In 35 years of driving, this is the best vehicle I have ever owned.

I get 25...

This was a great article, very straightforward, helpful, and exactly what I needed. Now I can load my data without just truncating and reloading. Thanks!:w00t:

anthony.green (8/28/2012)

---

Delete the rdl.data files from within the solutions folder.

I also tried the change of the value to not cache files but it still does, this manual delete is the...

Toreador (6/28/2012)

---

bitbucket-25253 (6/28/2012)

---

My hope is, those who complained just as you have, (or made an assumption) do not read job or project specifications at work in so careless a manner...

Nice, simple, and informative (especially the EXCEPT which I never use). the alternatives were also interesting. 🙂

Jeffrey Williams 3188 (3/24/2012)

---

In the organizations I have worked for - we utilize Ghost or something similar to build workstations. I tell developers that if they do anything that...

Lynn Pettis (3/23/2012)

---

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

msmithson (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

Just as long as the developer knows that if he hoses his system he is on is own, ensures that all required...