SQL Performance

DECEMBER 11, 2019

Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. WHERE NOT ( shippeddate = '20190102' ) ; This query returns the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

Best Practices 117

Best Practices C++ Database Code 117

Sutter's Mill

FEBRUARY 13, 2017

I don’t get to Europe very often apart from ISO C++ standards meetings, but this spring I’ve been able to accept invitations for two English-language European events in the last week of April. Tue-Thu Apr 25-27: High-Performance and Low-Latency C++ (Stockholm). Will C++ continue growing forever? Description.

Latency 48

Latency C++ Hardware Performance 48

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. Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. With faster disks (i.e. AWS Aurora (based on MySQL 5.6) select one row only, no index.

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

SEPTEMBER 5, 2019

CREATE CLUSTERED COLUMNSTORE INDEX c ON #T WITH ( MAXDOP = 1 ) ; Run the following test queries against the new columnstore table: SELECT. c = COUNT_BIG ( * ) FROM #T AS T WHERE 1 = ( SELECT 1 ) -- Avoid trivial plan. You can skip the WHERE clauses if you are running SQL Server 2017. c1 = @Start + N.

Performance 81

Performance C++ Storage Servers 81

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. However, from relational theory's standpoint, there's a deeper meaning to what C represents. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Microbenchmark os::javaTimeMillis() on both systems. us on Ubuntu.

Speed 103

Speed Java AWS Virtualization 103

Tech News Gather

NOVEMBER 22, 2022

There are numerous JVM languages available for use when developing Android apps. The application world began to move forward after Google announced Kotlin as the new programming language for Android Apps at the 2017 I/O conference. In October 2017, Android 3.0 Reasons to choose Kotlin for App Development.

Development 52

Development Java Programming Google 52

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

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In addition, there are fewer resources, plugins, libraries, third-party tools, and sources of support available than for other, more established database systems. Scalability and replication options that can improve performance and high availability.

Open Source 52

Open Source Servers Storage Scalability 52

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 139

Google Open Source Programming Code 139

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. Today’s choice is a report from a 2017 workshop convened with that title, and recommended to me by John Allspaw – thank you John! Take a trivial example with three components A, B, and C.

C++ 50

C++ Systems Software Software 50

SQL Server According to Bob

FEBRUARY 13, 2020

Note:​​ My colleague, Pat, enhanced the SQL Server VDI feature allowing VDI backup/restore utility support on Linux for SQL Server 2017 so you always have your choice in backup/restore storage providers on Linux and Windows.

Servers 40

Servers Availability Transportation Database 40

Enprowess

NOVEMBER 2, 2021

Its first release was in May 2017 and was rarely used by developers, but it continues its speedy growth and becomes more and more popular in the developer community. Seamless integration : There is no need to Re-write code because it easily integrates with Swift or Objective C for iOS apps and Java for android. Flutter Overview.

Development 52

Development Social Media Mobile Code 52

Brendan Gregg

SEPTEMBER 25, 2021

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 html [60s checklist]: /Articles/Netflix_Linux_Perf_Analysis_60s.pdf [re:Invent talk]: [link] [recommendation]: [link] [Nitro]: /blog/2017-11-29/aws-ec2-virtualization-2017.html

Speed 40

Speed Java AWS Virtualization 40

SQL Server According to Bob

JANUARY 29, 2017

Launch: lldb -c core.sqlservr.8917 Thus, LLDB is not reading the available PT_LOAD headers and the region of memory needed appears after the 65535th entry. FEB 1, 2017 UPDATE – CHANGE ACCEPTED. Using the -O command line parameter, when you start LLDB, indicates to LLDB to execute the command before the files are loaded.

Servers 40

Servers Programming Media Open Source 40

Randon ASCII

APRIL 17, 2018

The diagnosis is that file notification buffers are allocated out of pool memory ( ExAllocatePoolWithTag ) and then filled with the available notification data. It shouldn’t take much C# code to make an app that monitors the root of all drives, using buffer sizes that start small and gradually get larger. You know where to find me.

Monitoring 43

Monitoring C++ Code Processing 43

SQL Performance

JANUARY 8, 2020

A much more elegant option is to use the CONCAT_WS function, which was introduced in SQL Server 2017. ( 1 , 'A' , 100.00 ) , ( 2 , 'B' , 200.00 ) , ( 3 , 'C' , NULL ) ; Notice that contacts 1 and 2 have applicable hourly rates, and contact 3 doesn't, so its hourly rate is set to NULL. 3 C NULL 4 D 150.00

Design 65

Design C++ Code Database 65

Smashing Magazine

JANUARY 21, 2019

Hence, the API can be implemented on any language (which is one of the beauties of GraphQL: being a specification and not an actual implementation has enabled it to become available in a myriad of languages.). The code implementing the API as explained in this article is available in this open-source repository. API response example.

Social Media 73

Social Media Database Media Website 73

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Filesystem Type 1K-blocks Used Available Use% Mounted on.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

AUGUST 8, 2017

TABLE OF EXP(-T/C) FOR T = 5 SEC. EXPFF: EXP 0.920043902 ;C = 1 MIN EXP 0.983471344 ;C = 5 MIN EXP 0.994459811 ;C = 15 MIN. rc5-virtual (bgregg-xenial-bpf-i-0b7296777a2585be1) 08/01/2017 _x86_64_ (8 CPU) 10:15:51 PM UID PID %usr %system %guest %CPU CPU Command 10:16:51 PM 0 18468 2.85 3 tar termb$ iostat -x 60. [.]

Latency 111

Latency Metrics C++ Systems 111

The Morning Paper

NOVEMBER 21, 2019

The contrast output above tells us for example that we can safely measure the impact of a dynamic bitrate policy across the board, but we need to much more careful if we want to start analysing the impact based on market or maximum available bitrate.

Programming 52

Programming Internet Internet Design 52

John McCalpin

JANUARY 22, 2018

A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing) Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC.

Latency 40

Latency Hardware Code Testing 40

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing). An illustrative example: .

Latency 40

Latency Hardware Code Testing 40

SQL Server According to Bob

JANUARY 28, 2018

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. This means there are no DTC components available for SQL Server 2017 on Linux. include “stdafx.h”

Servers 40

Servers Azure Engineering Java 40

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 111

Performance Cache Network Metrics 111

The Netflix TechBlog

OCTOBER 14, 2024

Upon closely examining the user’s Notebook, we noticed a library called pystan , which provides Python bindings to a native C++ library called stan, looked suspicious. This file was introduced in this commit in 2017, with the purpose of improving the performance of user programs that determine aggregate memory statistics.

Latency 214

Latency Virtualization Traffic Processing 214

Percona

JANUARY 14, 2019

To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. This is all true for ClickHouse, however, we may be able to live with it for our task.

Database 48

Database Analytics Blockchain Healthcare 48