SQL Server According to Bob

JUNE 3, 2016

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.

Hardware 40

Hardware Cache Servers Software Engineering 40

Scalegrid

JULY 17, 2020

2014) added support for JSONB data type. JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB storage results in a larger storage footprint. JSONB storage does not deduplicate the key names in the JSON. JSON database in 9.2

Storage 321

Storage Database Efficiency Processing 321

Dynatrace

AUGUST 11, 2022

The FaaS model of cloud computing debuted in 2014 with startups like hook.io. Infrastructure as a service (IaaS) handles compute, storage, and network resources. Consider a monolithic application, for example, designed to perform a host of functions. But how does FaaS fit in? This, in turn, helps to maximize resource use.

Development 250

Development Serverless Best Practices Lambda 250

CSS Wizardry

MARCH 3, 2019

Tip: There are a number of directives that Clear-Site-Data will accept: "cookies" , "storage" , "executionContexts" , and "*" (which, naturally, means ‘all of the above’). a CDN), to always serve the freshest possible copy, and not to persist anything to storage. Steve Souders , 2014. Caching – 2014. Examples and Recipes.

Cache 264

Cache Latency Strategy Servers 264

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers.

Programming 98

Programming Code Design Benchmarking 98

SQL Performance

MAY 1, 2019

For SQL Server 2014 and later , the transition point is 950 rows for this table. The way the calculation is performed is slightly different in SQL Server 2012 and earlier compared with SQL Server 2014 and later. In SQL Server 2014 and later , the changes are: The row size is calculated by the metadata generator.

Servers 47

Servers Database Testing Performance 47

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz. Figure 2: Microsoft Project Olympus. Memory (GiB).

Azure 42

Azure Virtualization Storage Benchmarking 42

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.

Availability 40

Availability Servers Hardware Benchmarking 40

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. Delayed three years ( Chrome 40, November 2014 vs. Safari 11.1, A subset ( element.animate() ) has enabled developers to more easily create high-performance visual effects with lower risk of visual stuttering in Chrome and Firefox since 2014. Service Workers.

Media 145

Media Games Education Engineering 145

Abhishek Tiwari

NOVEMBER 3, 2018

They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Alternatively, you can upload output directory to cloud object/blob storage such as Amazon S3 or Azure Blob Storage and serve your site from there.

Systems 63

Systems Cache Website Network 63

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. mid-priced Androids were slightly faster than 2014's iPhone 6. Chip design choices and silicon economics are the defining feature of the still-growing Performance Inequality Gap.

Performance 124

Performance Network Cache Metrics 124

SQL Server According to Bob

DECEMBER 31, 2018

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. Large traces can encounter the 32-bit SSMS memory limitations. textBoxDisplay.Text += strText; } } } } }. Designer.cs. BeginInit(); this.splitContainer1.Panel1.SuspendLayout();

Efficiency 40

Efficiency Code Servers Cache 40

Percona

JANUARY 14, 2019

In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel. At the same time, it was not originally designed that way. codecs','imgur','floppy','codec','adobe','android'] ? ? scala','currency','println'] ? ?

Database 40

Database Analytics Blockchain Healthcare 40