SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90

Servers Media Cache Storage 90

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) MySQL on ec2.

Cache 47

Cache C++ AWS Airlines 47

Adrian Cockcroft

JANUARY 29, 2023

A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). > system.time(wait1 <- normalmixEM(waiting, mu=c(50,80), lambda=.5, What Is the Expected Distribution of Website Response Times? . >

Lambda 98

Lambda Latency Cache C++ 98

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

SQL Performance

MAY 13, 2020

As a result, in the same level of nesting, column aliases that you define in the SELECT clause are only available to the ORDER BY clause. They are not available to the rest of the query clauses. In my examples I'll use a sample database called TSQLV5. C is what's known as a range variable. Orders AS O ON C.

C++ 143

C++ Code Design Servers 143

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. As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c

Speed 40

Speed Java AWS Virtualization 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. The SQL Server ODBC driver is built for Windows and linked with the MSDTC libraries but the SQL Server JDBC implementation is not Windows specific and does not have the msdtcprx.dll or service available on the client. Transaction Monitor/Manager – Coordinator.

Servers 40

Servers Azure Engineering Java 40

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 2 B 200.00

Design 65

Design C++ Code Database 65

Smashing Magazine

JANUARY 21, 2019

Following, the API will add the database object data. This information is not placed under each module, but under a shared section called databases , to avoid duplicating information when two or more different modules fetch the same objects from the database. In other words, database object data is normalized.

Social Media 64

Social Media Database Media Website 64

Smashing Magazine

JANUARY 7, 2019

Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Still, it’s not that difficult , and its support is coming, e.g. it’s available since Apache 2.4.26.

Performance 103

Performance Cache Metrics Network 103

O'Reilly

MARCH 23, 2023

An API for ChatGPT is available. GPT-3 and GPT-4 are not open source, but are available for free and paid access. Poe is a chat app based on Claude, and available through Quora; there is a waiting list for access to the Claude API. LLaMA Developed by Facebook/Meta, and available to researchers by application.

Google 104

Google Open Source Programming Code 104