2016 Database Software Engineering Testing 
SQL Performance
APRIL 17, 2020
Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only. 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.
SQL Server According to Bob
JUNE 3, 2016
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. The following chart shows the same 1TB database testing. SQL Server 2016. SQL Server.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Server According to Bob
JUNE 3, 2016
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. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. – [link]. Auto-soft NUMA.
SQL Server According to Bob
JANUARY 28, 2018
Resource Manager – Database, File System, with ACID capabilities. Microsoft specific implementation for DTC using (OLE-TX). X/Open Standard for TM to RM communications and behavior. Transaction Monitor/Manager – Coordinator. Microsoft MSDTC protocol. Transaction GUID used by MSDTC, often referred to as a UOW (Unit-of-Work).
SQL Server According to Bob
DECEMBER 18, 2018
Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Val and Dylan performing power outage durability testing and adding new tests. The Back Story.
Expert insights. Personalized for you.
63 
Let's personalize your content