article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Tune and optimize to improve performance Even if you consider your database platform modern, simple database tuning and optimization can speed up your processes significantly.

article thumbnail

Jamstack CMS: The Past, The Present and The Future

Smashing Magazine

However, unlike the early days of the web, static sites are no longer limited to developers working in a code editor. Piecing together a website using a WYSIWYG editor and seeing the code it generated was a fascinating and educational experience that sparked an initial interest in web design. Editing a blog post in MovableType 2.0

Ecommerce 139
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

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. The code may be easier to read and understand than the recursive CTE.

Servers 86
article thumbnail

The Surprising Effectiveness of Non-Overlapping, Sensitivity-Based Performance Models

John McCalpin

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

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

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. Higher memory speed and bandwidth. Single-threaded CPU performance is the one relative weak point of the AMD EPYC 7742 processor. Higher memory density/capacity.

Servers 52
article thumbnail

Compiler bug? Linker bug? Windows Kernel bug.

Randon ASCII

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? I was doing a lot of builds because I was doing build-speed investigations and these crashes were interfering with my ability to do measurements. 00000001400010A1 00 00 add byte ptr [rax],al.