O'Reilly

JANUARY 16, 2024

I even contributed my own hot take last year with my O’Reilly Radar article Real-Real-World Programming with ChatGPT.) What more is left to say by now? ChatGPT was released just over a year ago (at the end of November 2022), and countless people have already written about their experiences using it in all sorts of settings. (I

Entertainment 73

Entertainment Internet Internet Design 73

SQL Performance

MAY 12, 2021

In this article we’ll put this intuitive assumption to the test. The best performing T-SQL solution that didn’t use any persisted base tables (other than the dummy empty columnstore table to get batch processing), and therefore involved no I/O operations, was the one implemented in the function dbo.GetNumsAlanCharlieItzikBatch.

C++ 111

C++ Servers Database Code 111

Smashing Magazine

MARCH 7, 2022

In my last article , I suggested using the SaveData API to deliver a different, more performant, experience to users that expressed that desire. In this article, I want to spend a bit more time on this, and also look at other signals we can similarly use to help us make decisions on what to load on our websites. Barry Pollard.

Website 103

Website Media Mobile Network 103

SQL Performance

APRIL 23, 2019

SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Introduction. Columnstore storage. It can be used with non-numeric data.

Servers 67

Servers Testing Metrics Storage 67

All Things Distributed

JANUARY 29, 2017

This article titled " Überlebensstrategie für die digitale Transformation " appeared in German last week in the "Die Zukunft beginnt heute (the future starts today)" section of Wirtschaftwoche. Smaller companies have a lot to gain in the digital era – provided they adopt the right mindset. The digital era is here.

Strategy 109

Strategy Innovation Entertainment Hardware 109

All Things Distributed

JUNE 28, 2017

This article titled " Wartet nicht auf Perfektion – lernt aus euren Fehlern! So if you can't wait for perfection, what should you do instead? So if you can't wait for perfection, what should you do instead? Our systems must be able to evolve and become more resilient to failure.

Innovation 113

Innovation Website Servers Technology 113

Highly Scalable

MARCH 10, 2015

Over years, this article has evolved into a book – please visit Introduction to Algorithmic Marketing website to download]. In this article we are trying to take a more rigorous approach and provide a systematic view of econometric models and objective functions that can leverage data analysis to make more automated decisions.

Retail 152

Retail C++ Analytics Metrics 152

SQL Performance

SEPTEMBER 17, 2019

This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation. The ReportServer database is encrypted and certain operations require restoring the symmetric key. SSRS 2008 brought that component into the reporting service module.

Tuning 67

Tuning Servers Database Best Practices 67

Smashing Magazine

JANUARY 11, 2021

How do we actually know where we stand in terms of performance, and what exactly our performance bottlenecks are? So, if we created an overview of all the things we have to keep in mind when improving performance — from the very start of the project until the final release of the website — what would that look like?

Performance 145

Performance Cache Media Metrics 145

SQL Performance

NOVEMBER 13, 2019

With the former, you just don't care in what order they are assigned, and whether repeated executions of the query keep assigning the same row numbers to the same rows or not. This article explores different techniques for computing row numbers with nondeterministic order. When order matters. I'll use a table called T1 in my examples.

Servers 104

Servers C++ Storage Performance 104

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Nick Desaulniers

APRIL 18, 2014

But you never can tell exactly what the compiler is doing. Or maybe if you’ve ever tried to hand write x86-64 assembly, and got stuck trying to understand the tooling or seemingly random segfaults from what appears to be valid instructions. ’” “The machine language of the world,” Hiro says.

C++ 98

C++ Programming Code Virtualization 98

Smashing Magazine

JANUARY 6, 2020

How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? So, if we created an overview of all the things we have to keep in mind when improving performance — from the very start of the process until the final release of the website — what would that list look like?

Performance 145

Performance Cache Network Metrics 145

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40