2014 Availability Database Storage 
Percona
JUNE 4, 2023
Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.
SQL Performance
MARCH 17, 2020
Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
MAY 16, 2019
If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. For SQL Server 2014 and later, the uniquifier is correctly omitted for unique indexes, but the one extra byte for the internal bit flag is retained. If it can internally guarantee ordering in other ways, the Sort may be omitted.
Scalegrid
JULY 17, 2020
Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. 2014) added support for JSONB data type. JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns.
Brendan Gregg
NOVEMBER 29, 2017
At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. The AMI and boot are now HVM.
SQL Server According to Bob
SEPTEMBER 26, 2016
When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.
SQL Performance
MAY 1, 2019
The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2014 and later , the transition point is 950 rows for this table. The thresholds are not dependent on the Cardinality Estimation model in use or the database compatibility level.
Expert insights. Personalized for you.
52 
Let's personalize your content