article thumbnail

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward. ALTER COLUMN id bigint NOT NULL ; Thanks to the improvements in SQL Server 2016, this command changes metadata only , and completes immediately.

Servers 63
article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. You can take advantage of this effort packaged in SQL Server 2016. SQL 2016 supports 3X more physical memory than previous versions. – [link].

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

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40
article thumbnail

Weekend Reading: Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases.

All Things Distributed

We decided to use our inventive powers to design and build a new database engine that would give database systems such as MySQL and PostgreSQL reliability and performance at scale, at a level that could serve even the most demanding OLTP applications.

Database 120
article thumbnail

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases.

article thumbnail

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

While we were confident in the design of SQL Server 2012, several customers reported to us performance problems that did not appear to be with disk subsystems, CPU, or networks. Our design needed to scale and be adaptable to the modern hardware on the market. First, we looked at the overall architecture of the replica design.

article thumbnail

Exploring Kubernetes Operators

Percona Community

The concept of Kubernetes Operators was introduced around 2016 by the CoreOS Linuxdevelopment team. Kubernetes is designed for automation, offering essential automation features. According to the Cloud Native Computing Foundation, “Operators are software extensions that use custom resources to manage applications and their components”.

Cloud 58