that means that on that particular cube one of the tables has a record that exceeds the max of 64KB

you will need to identify what it is and potentially remove...

possible way - not the prettiest and probably not the best one - and not sure if it will work for all periods you may have

code adapted from https://dba.stackexchange.com/questions/174035/split-duration-hourly-depending-on-start-and-end-time

Requirements copied...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.
• This reply was modified 5 years, 6 months ago by frederico_fonseca.
• This reply was modified 5 years, 6 months ago by frederico_fonseca.

you may be suffering from the change to bulk insert since 2016.

have a look at https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537

if this is the reason you will need to either change your load processes to...

This is akin to asking "whose responsibility is it to provide a quality product"?

Everyone's responsibility should be to make their work the best they can, not depend on other...

from my point of view it should be primarily on the developer - and organizations that do not give the tools to their developers to improve their code are loosing...

you can easily update the code I supplied to flag when a circular happened - I would be pretty sure that that is what is happening to you

potentially outputting the...

Normally when I am working with rCTE I add a column to prevent circular dependencies (which is what normally causes the max recursion error)

example below is to do with Active...

I think it...

According to licensing terms Developer only on a...

same as I gave original - do the data migration yourself without using SSMA

none of those are replacements for RDCMAN - those are just Remote Desktop options

just one list - will not recommend any as you will be the one that needs to...

did you even bothered googling for it?  replacement for RDCMan shows lots of hits

did you grant permissions (read/write/list) to everyone to the temp folder of the user that the instance is running under? - this as per my second link above.

For network accounts,...

Definitely there isn't even a need for db_owner for developers.

Based mainly on the work from Solomon I have implemented a solution in one of our servers (to be expanded to...

• This reply was modified 5 years, 7 months ago by frederico_fonseca.

some people have difficulty understanding what they are being asked to do so lets see if a explanation with images help.

follow the instructions on this link to see if you...