Based on that comment, it seems a sure bet that Auto Tuning is similar to the nonsense coming from the DTA. Wide keys and a bazillion INCLUDEs to build covering indexes for virtually everything with unnecessary stats on a similar number of columns. Heh... as the Nabisco Company advertised for one of their leading cracker products way back in the '70s, "You can change the wrapper but it's still the same old Ritz". 😀
Seems like a clever way for MS to increase storage costs in Azure for those that may not know better. And I'll bet your DBA also goes nuts when it comes to stats and index maintenance. I wonder which Fill Factor they assign to the indexes that Auto-Tuning creates.
is pronounced "ree-bar
" and is a "Modenism
" for R
ow.First step towards the paradigm shift of writing Set Based code:________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.
Helpful Links:How to post code problemsHow to Post Performance ProblemsCreate a Tally Function (fnTally)