SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
I am indeed very delighted to share my suggestion about MariaDB Learning Path. Five video courses published on the Pluralsight.
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.
Essentially, they wanted to know command which can Show Engines to Display All Available and Supported Engine in MariaDB.
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.
As a database professional, one should know multiple database platforms as in the real world we can’t say no to our clients when they show up a system which is running slow and involves multiple database platforms. During the Comprehensive Database Performance Health Check engagements, I have seen quite many different databases like ProstgreSQL, MySQL and MariaDB. In this blog post, I am going to discuss my newly released course on Pluralsight – Getting Started with MariaDB.