Viewing 15 posts - 2,341 through 2,355 (of 39,720 total)
Data Quality is a big deal, and sampling can be good, but we've also seen lots of sampling bias that comes out later. Of course, we also have overwhelming data...
September 9, 2020 at 2:34 pm
Your backup command needs the shared keys to access a blob. Your account just needs normal backup rights
September 8, 2020 at 9:41 pm
Are you looking to use the Notifications from the job metadata?
You can always add a step to send something through Database Mail
September 8, 2020 at 9:40 pm
This is an illustration, not real code. Presumably, you might have lots of other code that checks for the need to rollback.
However, I'm not sure SET and SELECT impact the...
September 8, 2020 at 3:42 pm
Forgot about the draft, got a mix of decent players, I think. No idea how to judge who to start.
September 7, 2020 at 10:36 pm
I wish, and we've debated this. There is some caching taking place because some of these summary pages (/forums, /active, etc.) are heavy on the db, so we have a...
September 4, 2020 at 5:43 pm
I assume you have the same structure locally and are just duplicating this in S3? I haven't tested this, but it looks reasonable. I see your same code on SO...
September 4, 2020 at 2:59 pm
Hope for the best, plan for the worst. I tend to follow that in most of life.
September 4, 2020 at 2:53 pm
Closing as duplicate
September 4, 2020 at 2:50 pm
Take it. Should be a short, easy one.
September 3, 2020 at 4:38 pm
As Jeff noted, include TRUNCATE in here.
September 3, 2020 at 4:09 pm
There were distributed partitioned views, but these didn't work well, created dependencies and didn't necessarily help performance - https://techcommunity.microsoft.com/t5/datacat/distributed-partitioned-views-federated-databases-lessons/ba-p/304955
Not sure they're still around. You can use a linked server...
September 3, 2020 at 4:07 pm
Viewing 15 posts - 2,341 through 2,355 (of 39,720 total)