One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.
However, whenever we are exploring the new feature, it is a good idea that we work with the sample database and build our scripts
The most questions were around section Poor Indexing Strategies and that lead me to write about 10 Don’ts for Indexes. Let us talk about it today.
Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.