we tried your idea Ed B, thank you.   I think its going to help in the long run.  At  the same time we temporarily decreased sql server's (the engine) high...

it appears to run.

{

"sequence": {

"maxParallelism": 1,

"operations": [

{

"refresh": {

"type": "clearValues",

"objects": [

{

"database": "MyDB"

}

]

}

},

{

"refresh": {

"type": "full",

"objects": [

{

"database": "MyDB",

"table":"Table1"

}

]

}

},

{

"refresh": {

"type": "full",

"objects": [

{

"database": "MyDB",

"table":"Table2"

}

]

}

},

{

"refresh": {

"type": "full",

"objects": [

{

"database": "MyDB",

"table":"Table3"

}

]

}

},

{

"refresh": {

"type": "full",

"objects": [

{

"database": "MyDB",

"table":"Table4"

}

]

}

},

{

"refresh": {

"type": "full",

"objects": [

{

"database":...

it used to be that you could see on the page itself what versions of sql a particular subject applied to.  Now its more of a mystery.   when i get...

hold the phone.  I havent tried it yet but here is a link that explains how to mix sequence and refresh.   I have to stare at the curly braces to...

no problem.  I moved the memory part of the discussion to a different thread.    And i'll mark your post here as an answer.

thanks Phil.   I couldnt see how to author the sequence command along with the refresh format i showed in the original post.   I think MS is telling us that only...

my thought was that a "thread" would lessen the chance of a memory error.   And that that was one of the tricks out there for getting around some memory issues. ...

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

thanks, does anybody have access to enterprise?   The reason i ask is that there was a time when you had to use a backdoor thru multidimensional   to achieve this form...

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

thx Eirikur,

throttling in this context means he gets some relatively lower priority if we go with a "live experience".  That (live experience) should have been clear from the original post. ...

thx frederico.  we are doing a process full at the moment.  going to read your link which probably contains the guidance phil was giving also.  it would have been so...

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

thx Jeff for your time.   Unfortunately the reports needing the data are operational.   So the data they need is pretty detailed.   So the volume is going to be a factor...

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

thx phil

thx Jeff, you are basically suggesting ETL loading data incrementally after reshaping into a star.   we actually talked about that but arent ready.  we do it in other business areas...

ssrs but i think we got it figured out.  thx

yes, now i can.   appreciated.  will try running one of (there's only one right now anyway) the pkgs from sql agent shortly.