Viewing 15 posts - 1 through 15 (of 37,388 total)
Moving those frequent v rarely queried columns can make a huge difference. It's almost like a covering index for a variety of queries using those columns.
September 15, 2020 at 5:56 pm
You should see something like this. My 2019 Express container (comment is the @@version data) shows JSON works
September 14, 2020 at 4:43 pm
If they want rows for insurance, getting the rough size from the metadata tables and then the table size might give you a guess of rows.
September 14, 2020 at 3:24 pm
A Jupyter book is a collection of notebooks.
If you just want a notebook (page), then just create the notebook and add the text or cells as needed.
Also, they're revving this...
September 14, 2020 at 2:45 pm
I did watch some Thur night, but then I forgot football was going until I took a break from chores yesterday and realized games were on. Yahoo did my right, as...
September 14, 2020 at 2:00 pm
Glad you got it to work and thanks for the update.
September 11, 2020 at 4:49 pm
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