Remove 2008 Remove Availability Remove Code Remove Storage
article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. Some key features and functionalities of MySQL include: Support for multiple storage engines, allowing users to choose what is suitable for their needs.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance.

Servers 86
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Expanding the Cloud for Windows Developers - All Things Distributed

All Things Distributed

Using the AWS Toolkit for Visual Studio , you can now deploy your.NET applications to AWS Elastic Beanstalk directly from your Visual Studio environment without changing any code. of administrative tasks such as OS and database software patching, storage management, and implementing reliable backup and disaster recovery solutions.

Cloud 115
article thumbnail

Strongly Type Those Table-Valued Parameters

SQL Performance

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55
article thumbnail

AMD EPYC 7002 Series Processors and SQL Server

SQL Performance

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. Among the 19 public processor SKUs, there are preferred choices for SQL Server at each available core count. Preferred AMD EPYC Processors.

Servers 52
article thumbnail

iOS Engine Choice In Depth

Alex Russell

Anyone who cares to download and fork the code can do so. From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." The signal to parties who might contribute code for these features could scarcely be clearer: your patch is unlikely to be accepted.

article thumbnail

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The FastLoadContext code path adds support for minimally-logged and concurrent bulk load on: Empty and non-empty clustered b-tree indexes. There are two main code paths that can set DMLRequestSort to true for index inserts. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64