Viewing 15 posts - 1,666 through 1,680 (of 2,693 total)
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...
March 14, 2020 at 1:26 am
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...
March 12, 2020 at 9:27 pm
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...
March 12, 2020 at 5:27 pm
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...
March 12, 2020 at 3:22 pm
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...
March 12, 2020 at 11:49 am
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...
March 12, 2020 at 10:40 am
Thanks folks. Still looking to find out if AWS RDS will support the Developers Edition or not. I'd look for myself but I don't yet have access.
I think it...
March 11, 2020 at 11:44 pm
Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?
According to licensing terms Developer only on a...
March 11, 2020 at 7:37 pm
same as I gave original - do the data migration yourself without using SSMA
March 11, 2020 at 5:01 pm
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...
March 11, 2020 at 4:45 pm
did you even bothered googling for it? replacement for RDCMan shows lots of hits
March 11, 2020 at 1:02 pm
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,...
March 10, 2020 at 1:01 am
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...
March 9, 2020 at 7:42 pm
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...
March 9, 2020 at 8:09 am
frederico_fonseca wrote:... spawning 2 -3 weeks) instead of getdate to see its variation
I think you mean 'spanning'.
yeah..
March 8, 2020 at 11:54 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,693 total)