yes, i usually consider that road but am very careful not to create a new "cottage industry".  By that I mean a whole new process whereby people have to take...

thx scott is a checkpoint equivalent "result wise" to setting a log as reusable?   i was surprised to hear i needed to set a log as reusable.  but i have...

no problem frederico.   your idea about partitioning jumped into my head early on also.  i have to read jeff's link before i do anything.

thx frederico, not sure but i think our recovery simple choice addresses your point about logging mode.   and yes i've seen backups run in seconds on this 105 gig db.

But...

thx Jeff, so how do we mark the log reusable after the 12th erp is done?   I wasnt clear in my post but should have stated that no one erp...

thx frederico, i tried to explain that one erp is always a full, the other 11 are generally (more than 99%) done with an incremental algorithm.

thx phil.   no i looked closely at the view definition too.  but that is when / after all the records are committed.

when i strip out all the left joins, what...

• This reply was modified 1 year, 7 months ago by stan.
• This reply was modified 1 year, 7 months ago by stan.
• This reply was modified 1 year, 7 months ago by stan.

thx Brian, that makes a lot of sense and we already nixed the idea of a laptop for other reasons.   But your reasons are better than ours.  We started talking...

thanks phil, do you mean all on the same single pc?   That's the kind of feedback i was hoping for.   That way no one instance of sql could interfere with...

thx, so those 2 selects are mdx.   i was able to run them right on the ssas instance without a linked server.  But i understand the value in having a...

• This reply was modified 1 year, 7 months ago by stan.

thank you chrissy321,

i read your link quickly and see if i have an mdx query, it would be sent native thru openquery probably via a new query from a db...

thx chrissy321.  Where would i run that?  in the engine on the same server where ssas is?  I dontg think t-sql ius a choice of language on the ssas instance. ...

thx lowell, by any chance do you also know how to get a list of members/groups from each role under a tabular model database?   I might have asked too  many...

thx Jeffrey, that was all laid out in the original post and i believe showed nothing was restricted at least palette wise.

But your answer gave me an idea that i...

hi jeffrey, by palette did you mean the tablix/subreport link on the master report?  If yes, i expanded that to cover the whole page and everything works.  let me kinow...