Are you rebuilding the index? A rebuild should result in reduced fragmentation.

BTW, if you're not experiencing lots of scans, it's possible that you don't need to worry that...

It's largely the same. Good code, good structure, proper indexes, statistics up to date, these are what you have to do. The difference is, as you tune the queries, you...

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...

No. According to the documentation, that won't work with Azure SQL Data Warehouse. It also doesn't work with APS.

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...

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...