Moar Azure

Question

Post reply

Moar Azure

Steve Jones - SSC Editor

SSC Guru

Points: 722476
More actions
June 20, 2020 at 12:00 am

#3764293

Comments posted to this topic are about the item Moar Azure

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 109992 More actions · Answer 1

From what I saw last years, 95% of that increased workload are table scans, hash joins, endless data replications due to horrible indexing strategies and overall dumb database design.

at least I can see why Microsoft recommend clustered primary key on identity columns - it sells a lot of Asure service.

TallyGenerator

John Langston SSCommitted Points: 1913 More actions · Answer 2

The Azure SQL Database world has improved over the last four years based upon what I have observed. The other day I tried to provision an elastic pool in US North Central and received a message informing me that this was not possible with the particular subscription I was using so went to US Central. This was the first time I had seen such a message.