SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). Once the connection to SQL Server is established the APP executes the odbc! Microsoft specific implementation for DTC using (OLE-TX).

Servers 40

Servers Azure Engineering Java 40

SQL Performance

MAY 13, 2020

In my examples I'll use a sample database called TSQLV5. Customers AS C WHERE country = N'USA' ; Also here, the common assumption is that AS C is just a way to rename, or alias, the table Customers for the purposes of this query, starting with the logical query processing step where the name is assigned and onwards. custid , O.

C++ 143

C++ Code Design Servers 143

SQL Performance

JUNE 14, 2019

In my examples I’ll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Customers AS C LEFT OUTER JOIN Sales. Orders AS O ON C. GROUP BY C. ORDER BY C. Here’s the solution query (call it Query 2) with the bug fixed: SELECT C.

Best Practices 93

Best Practices C++ Database Processing 93

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT *.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

JANUARY 8, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. A much more elegant option is to use the CONCAT_WS function, which was introduced in SQL Server 2017. 3 C NULL 4 D 150.00

Design 65

Design C++ Code Database 65

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting. ( SELECT *.

C++ 52

C++ Servers Code Efficiency 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. This server is spending about a third of its CPU cycles just checking the time! As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5.

Speed 126

Speed Java AWS Virtualization 126

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ A utility would issue the dbcc freeze to stop the I/O activity for the database. ​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted.

Servers 40

Servers Availability Transportation Database 40

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.

Cache 47

Cache C++ AWS Airlines 47

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. This server is spending about a third of its CPU cycles just checking the time! As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6.

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. It’s fast, too, but it’s not perfect.

C++ 59

C++ Servers Testing Database 59

O'Reilly

MARCH 23, 2023

It’s clear that ChatGPT is not your run-of-the-mill automated chat server. The LLaMA source code has been ported to C++ , and a small version of the model itself (7B) has been leaked to the public, yielding a model that can run on laptops. It can pretend to be an operating system. Or a text adventure game. It’s much more.

Google 104

Google Open Source Programming Code 104

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. This relationship can be expressed through an associative array (an array of key => property) on the server-side, in which each module states its name as the key attribute and its inner modules under the property modules. Large preview ).

Social Media 64

Social Media Database Media Website 64

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent.

Database 40

Database Analytics Blockchain Healthcare 40