How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’
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’.
Learn MySQL – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss about where we can learn MySQL online.
Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
MySQL – MariaDB – Writing the Very First Stored Procedure
While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure.
MySQL Preferred Engine – MyISAM or InnoDB
Most of my time is spent with my clients on the Comprehensive Database Performance Health Check. MySQL Preferred Engine – MyISAM or InnoDB