doodlingdba (2/10/2011)

---

Thanks for all the ideas guys!!

Maintaining two datasets is an inefficient way of doing things - but my data source is SSAS and i'm new to MDX so I...

kasaranenikiran-725528 (2/10/2011)

---

THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to...

clare.xia (2/9/2011)

---

Wow.. I can't believe I got all the attentions from SQL Gurus! This is a great learning experience for me!

Here are the references I have been using. Please...

Just send a mail to santa...

old backup of the Vm machine (assuming virtual env.)?

Any chance you have another system db corrupt that could cause this error?... just a hunch and maybe this could lead somewhere.

Hmm, I guess I chose the wrong person to quote. I merely intended to further explain "our" point of view :w00t:.

bulbanos (2/9/2011)

---

doodlingdba (2/9/2011)

---

thanks for the response. i'm using two different tables because visually that's what the user wants.

I managed to get this working in the end though! Basically the same...

franck.maton (2/9/2011)

---

Hello,

We're planning to implement a brand new SQL server 2008 R2 architecture. But I'm not sure of myself about SQL features (SSAS, SSRS, SSIS).

I work in a big society...

OR assuming that you don't have 1 000 000 sales man.

Use 2 table objects on the report. 1 filters top 5 asc, then other one desc.

Then in your sp...

Grant Fritchey (2/9/2011)

---

I suppose on pretty slow systems or off hours that makes sense to try. But on a reasonably heavily used system... you better be very quick with the...

GilaMonster (2/9/2011)

---

If it's run soon enough,...

I guess what apex means is that as long as you start to recover from the log before doing any other transactions of any types then you have a good...

Add this code to you report in the code section (report properties)

PUBLIC FUNCTION NDZ(Numerator, Denominator, DZResult) AS Double

IF Denominator = 0 THEN

RETURN...

I've got...