(Joseph.Pilov) SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans.
(Pinal Dave) I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server.
(Walter Garcia) In this post I’ll give to you the steps to compile Percona Server for MySQL 5.7.22 in Raspberry Pi 3. Why? Well because in general this little computer is cheap, has low power consumption, and is great to use as a test machine for developers.
(Gaurav Patole) This article shows you how to troubleshoot a specific symptom that you may encounter when configuring continuous deployment for Azure App Service.
(Gabriela D’Ávila) This tutorial demands a service restart since some flags here presented can not be dynamically changed
(Jeff Smith) It’s easier to run things unsecured.
(mgogala) One of the long time problems with Oracle is IO calibration. I am talking, of course, about DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure.
(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL.
(Allan Hirt) If you’ve been in hibernation, today you woke up to a world where Microsoft has embraced open source and Linux. What was once unthinkable is now happening. What is going on? Why am I even talking about this?
(Meg Bernal) Db2 12 for z/OS became generally available in October 2016. Last summer, Chris Crone and I wrote a two-part blog on two highly requested SQL enhancements.