SQL Performance

MAY 16, 2019

Both of the following tests must pass for SQL Server to choose to set DMLRequestSort to true when inserting to an empty clustered index with table locking specified: An estimate of more than 250 rows at the input side of the Clustered Index Insert operator; and. Test ; END ; GO. spt_values AS SV ; Plan Caching. DROP TABLE dbo.

Cache 67

Cache Servers Testing Storage 67

Percona

JUNE 4, 2023

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. In 2008, Sun Microsystems acquired MySQL AB, and then, in 2010, Oracle bought Sun Microsystems. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Randon ASCII

FEBRUARY 11, 2018

I don’t know what that means but my guess would be that that indicates more data being cached, which would be a good thing. I work on the Windows version of Chrome, and one of my tasks is optimizing its build system, which requires doing a lot of test builds. A Windows kernel file buffer bug from Server 2008 R2 to Windows 10.

Processing 72

Processing Programming Code Cache 72

SQL Server According to Bob

JANUARY 26, 2017

“Quick question about a behavior we’re seeing at a customer and in testing. Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

AUGUST 20, 2021

MovableType was one of the first static site generators on the market, although that term wouldn’t become popular until 2008. By the end of 2008, Tom Preston-Werner announces Jekyll — a simple, blog-aware, static site generator. Status checks are small programs to lint, run tests, or anything else you’d like to measure.

Ecommerce 140

Ecommerce Website Government Internet 140

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. As a consequence, a suitable insert with TABLOCK may still qualify for minimal logging via FastLoadContext if it fails the detailed RowsetBulk tests. Test ; END ; GO. GO. -- Clear the plan cache. CHECKPOINT ; GO. -- Main test.

Cache 64

Cache Testing Servers Code 64

SQL Performance

SEPTEMBER 6, 2022

Testing environment. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. SET NOCOUNT , XACT_ABORT ON ; -- Prevent plan caching for this procedure. -- See [link]. BEGIN TRANSACTION ; -- Test statement(s).

Database 98

Database Storage Testing Servers 98