I don't know of any way to "downgrade" a SSRS report from 2008 to 2005 -- the file formats are different as I understand it. I think you'd have...

I'm running on a dev box and I'm the only one on it, so I can do a check point and flush caches ect. to get reasonable timings.

I changed the...

See if this helps: http://blog.summitcloud.com/2010/01/multivalue-parameters-with-stored-procedures-in-ssrs-sql/

HTH,

Rob

What version of Report Builder are you using? It sounds like you're using a newer version of Report Builder which is saving the .rdl in a different format than...

Thank you for the link -- a good explanation of parameter sniffing. Perhaps you're on to something with parameter sniffing. My Confio tool (Ignite) did say that the...

Koen,

No, I'm not positive in what takes the report so long. I'm not sorting or filtering in SSRS -- that's all taken care of in the query; it's a...

Massan (7/28/2013)

---

I was thinking about someone who can mentor me in a way that is convenient both me and that person.

I like to be improving my skills ones a while...

When you manually process the cube (through SSMS) what is the error(s) it is spitting out?

A couple dumb questions:

1) Is there a RETAIL_YEAR column in your A_SALES_DAILY_FACT table? (I can't imagine why there wouldn't be if you just upgraded the DW db from 2000...

Turns out the problem was in the db and I was able to recreate the blocking/deadlock with the query in SSMS (though it happened far less than when run through...

bill-900846 (5/2/2013)

---

Rookie SSIS user on SQL2008R2. I need to list the names of the approximately 95 tables that are moving from one DB to another. Is there a...

sej2008 (5/1/2013)

---

I work on ssas using adventureworksDW2008 database for creting cube and understanding other features but if I want to convert my oltp database such as Northwind database where data...

You can't restore a newer/higher version of SQL Server to an older version (e.g. 2008 R2 --> 2000). You can go the other way (older to newer), though that...

Choose 3 🙁

Bruce Hendry (4/16/2013)

---

SSIS does not allow comparison of the varbinary data type; the output of HASHBYTES. So if I want to compare source and destination HASHBYTES within the Conditional Split...