There's nothing normal in SQL server.

It would be abnormal if the avg is 1M reads and then all of a sudden, it jumps 1000 folds to 1 Billion reads.

You certainly...

I see. So we're back to a simple if in ± 20 triggers. Sounds like the easiest doable way at the moment.

It only sounds like you got some tuning to do on that query!!!

With only 1 write per run, I wouldn't worry about it.

Why did they reject that option?

The only big overhead I see is the remember to change schema in 2 places rather than one.

Option z might be to create a db...

Glad to. I'd most likely turn it into a short article or script as well.

Thanks again.

Awesome.

One last question.. Got any links on how to configure the external tools so that I can link this script and make my own single click deploy function?

Linda Claes (1/18/2011)

---

Hi Ninja,

I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file)...

Another quick question for ya. Have you noticed in ssrs 2k5 that when you deploy to overwrite a report, the overwrite doesn't work or only works partially??

Any workaround...

Here's another idea that might require much less coding and QA.

How about copying the DDL of the tables involved and calling tblname_hist.

Then copy the forms in question (or even use...

And please post back the link here once you're done so we can vote on it (I've had this issue before and chose the recoding way. I would've loved an...

Good point. Also they can often suggest alternatives you had...

Are you able to do a simple select in the same excel file?

Windows 32 or 64 bit?

Sql 32 or 64 bit?

Are you able to do a simple select in the same excel file?

How about adding a computed column and index it? Index view?

That was doing a good job in 2003. I have not tried it since so maybe it can help you out.

There's a free trial so you should have enough...