Viewing 15 posts - 3,466 through 3,480 (of 22,210 total)
btio_3000 - Friday, December 1, 2017 10:25 AMThank you.so no way to do extended properties in Azure DW whatsoever?
December 1, 2017 at 10:52 am
December 1, 2017 at 8:56 am
December 1, 2017 at 8:49 am
I have seen the execution plan, that query is in serious need of...
December 1, 2017 at 8:01 am
December 1, 2017 at 7:11 am
I am surprised, shocked, horrified, dismayed, thunderstruck, flabbergasted and down right gobsmacked to find out that adding one clustered index on one table did NOTHING to improve a 25 page...
December 1, 2017 at 6:29 am
December 1, 2017 at 6:18 am
No. According to the documentation, that won't work with Azure SQL Data Warehouse. It also doesn't work with APS.
December 1, 2017 at 4:29 am
November 30, 2017 at 2:03 pm
You definitely sound like a good candidate for the in-memory tables. To get started, go here. Pay the most attention to the restrictions. It's a huge performance boost...
November 30, 2017 at 2:01 pm
Without seeing the setup and size and nature, my answers are going to be pretty generic.
Yes, more files on more disks can generally mean better I/O. Just make...
November 30, 2017 at 5:30 am
November 29, 2017 at 12:25 pm
Right here. Instant table/clustered index scans. No seeks. No performance tuning possible other than buying faster disks and more memory:
November 29, 2017 at 11:56 am[CoverageLengthMonthNumber]
Oops. I was so focused on finding the ARM template that I missed that part.
There is a very good document out there on it. I'll have to look...
November 29, 2017 at 11:25 am
Viewing 15 posts - 3,466 through 3,480 (of 22,210 total)