Viewing 15 posts - 136 through 150 (of 1,111 total)
I typically tell people I'm like a computer engineer, but my title on paper is data architect so I work with mostly data. Then I follow it up with the...
August 1, 2018 at 6:05 am
July 23, 2018 at 7:45 am
It depends.
I work with data that is highly denormalized. It works great because of columnstores. The simple structure allows for easy queries and for the use cases of...
July 22, 2018 at 10:16 pm
July 19, 2018 at 6:12 am
July 19, 2018 at 5:39 am
Yep, BULK INSERT is a great option. I used it as the sole way to slam 50 million+ records into a staging table and then use SP's to transform the...
July 19, 2018 at 2:45 am
July 18, 2018 at 5:57 pm
July 18, 2018 at 5:47 pm
July 18, 2018 at 8:39 am
July 18, 2018 at 6:01 am
Sounds like there may be some bottlenecks when the data lands such as indexes, primary keys and so forth if it's taking that long.
Regardless, what's stopping you from...
July 18, 2018 at 5:54 am
Yeah, it's not that big in comparison to what's out there obviously, but it's many many TB's.
The issue is not really the size of the data. I was...
July 16, 2018 at 8:33 pm
Viewing 15 posts - 136 through 150 (of 1,111 total)