Does that import in the correct format? Does it keep calculated columns on the report or that...

Brandie Tarvin (10/17/2011)

---

All right. It's time to complain. Grab your pitchforks, torches, tar and feathers. We're...

I guess you apply scripts to run this... just save those somewhere so you can rerun them.

Plan be would be scripting the whole db or use red-gate diff tools. ...

aurato (10/17/2011)

---

Everything seems up and running now. Gotta fix the uniqueness issue but thanks. You've been on both threads where I asked for help. Last one involved...

SQL Kiwi (10/17/2011)

---

Ninja's_RGR'us (10/17/2011)

---

Seems to be the issue of the day that estimated vs actual # of rows don't match.

Care to guess by how much is the estimate...

I never played there. But assuming the constraint...

Is the index/constraint enabled?

Seems to be the issue of the day that estimated vs actual # of rows don't match.

Care to guess by how much is the estimate off? ...

So what was the solution?

Steve Jones - SSC Editor (10/17/2011)

---

Look at restore filelist only - http://msdn.microsoft.com/en-us/library/ms173778.aspx

I recommend you not back up multiple backups to one file. It's a risk that's unnecessary and any problem...

Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.

Easy way to test is to put it out there and come back later to see the real cost. Keep in mind that most systems I tune are severly overpowered...

pwalter83 (10/17/2011)

---

Ninja's_RGR'us (10/17/2011)

---

Easy way to test for filters.

Start a new trace and start the standard (default) trace.

Depending on how SSRS plays here you might see something like SP_EXECUTESQL ... 'EXEC...

I'd be most happy to be proven wrong... 😉

Fair warning. That article assumes you can do basic tuning. That part we can't give away. It's acquired by 1000s...