Dynatrace

APRIL 5, 2021

Azure is a large and growing cloud computing ecosystem that empowers its users to access databases, launch virtual servers, create websites or mobile applications, run a Kubernetes cluster, and train machine learning models, to name a few examples. The growth of Azure cloud computing. Making the best use of Azure Functions.

Azure 204

Azure Serverless IoT Lambda 204

SQL Performance

OCTOBER 13, 2021

As you can see in Figure 1, thanks to the fact that the function got inlined, SQL Server was able to create an optimal plan that interacts directly with the underlying base table’s indexes. SQL Server caches the last executed plan, so it can show statistics for that execution, but by request, it doesn’t reuse the plan. SELECT TOP (@n).WHERE

Cache 144

Cache Strategy C++ Code 144

SQL Performance

SEPTEMBER 12, 2019

As an example with our task, suppose that you don't realize that the grouping element is determined implicitly, and you come up with the following query: SELECT shipperid , [ 2017 ] , [ 2018 ] , [ 2019 ] FROM Sales. So you're expecting to see only three rows in the result. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 114

C++ Servers Testing Processing 114

The Netflix TechBlog

APRIL 17, 2019

Intel and Netflix announced their collaboration on a software video encoder implementation called SVT-AV1 on April 8, 2019. SVT-AV1 uses parallelization at several stages of the encoding process, which allows it to adapt to the number of available cores including newest servers with significant core count. What is SVT-AV1?

Open Source 167

Open Source Scalability Speed Efficiency 167

SQL Performance

JUNE 14, 2019

However, a typical bug when converting the existing solution to one that applies the join is to leave the computation of the order count as COUNT(*), as shown in the following query (call it Query 1): SELECT C. Customers AS C LEFT OUTER JOIN Sales. Orders AS O ON C. GROUP BY C. ORDER BY C. Orders AS O ON C.

Best Practices 93

Best Practices C++ Database Processing 93

SQL Performance

FEBRUARY 12, 2020

Curiously, SQL Server's query processor already supports an internal comparison operator IS, which uses the same semantics as the desired IS operator I described here. Here's the complete solution code: WITH C AS. ( 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06. Figure 1: Plan for Query 1.

C++ 120

C++ Code Servers Database 120

SQL Performance

DECEMBER 11, 2019

As an example, suppose that you need to query the Sales.Orders table in the TSQLV5 sample database, and return orders that were shipped on January 2 nd , 2019. WHERE shippeddate = '20190102' ; It's clear that the filter predicate evaluates to TRUE for rows where the shipped date is January 2 nd , 2019, and that those rows should be returned.

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

APRIL 13, 2022

L0 AS ( SELECT 1 AS c. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise. I’ll assume you’re using an environment designed to support batch mode on row store either directly, e.g., using SQL Server 2019 Enterprise edition like mine, or indirectly, by creating a dummy columnstore index on the table.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

FEBRUARY 10, 2021

The fact that you enable Discard results after execution in SSMS doesn’t prevent SQL Server from sending the result rows to SSMS; it just prevents SSMS from printing them. But this option is available only starting with SQL Server 2019, which introduced scalar UDF inlining. L0 AS ( SELECT 1 AS c.

C++ 124

C++ Servers Testing Code 124

SQL Performance

APRIL 10, 2019

I posted a suggestion to improve SQL Server by adding support for RPR in T-SQL , but I was quite limited in the space that I had to provide the feedback. STOCK1 2019-02-12 150.00 STOCK1 2019-02-13 151.00 STOCK1 2019-02-14 148.00 STOCK1 2019-02-15 146.00 STOCK1 2019-02-18 142.00 STOCK1 2019-02-19 144.00

C++ 73

C++ Servers Virtualization Code 73

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. A few caveats before we begin: Data scraping involves increasing the server load for the site that you’re scraping, which means a higher cost for the companies hosting the site and a lower quality experience for other users of that site.

Scalability 89

Scalability Website C++ Servers 89

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. WHERE orderdate = EOMONTH ( DATEADD ( month , - 1 , SYSDATETIME ( ) ) ) ; Note that if you actually run this query in the TSQLV5 sample database you will get an empty result since the last order date recorded in the table is May 6 th , 2019.

C++ 111

C++ Database Servers Code 111

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. Description.

IoT 61

IoT Servers Development Cache 61

SQL Performance

MAY 6, 2021

This is the fourth part in a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. Part 3 started the query scan, performed some early phase processing, and started the first additional parallel tasks in branch C. Branch C execution details. Branch C (additional parallel tasks).

C++ 95

C++ Azure Servers Processing 95

SQL Performance

MAY 11, 2022

I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. SQL Server doesn't currently support an efficient combination of a parallel order-preserving input prior to a parallel batch-mode Window Aggregate operator. Environment for Demos. So, why does the plan have four sorts?

C++ 133

C++ Database Servers Code 133

SQL Performance

NOVEMBER 13, 2019

Never mind the likelihood for this to happen in practice in SQL Server; if I run the query again, theoretically, the row with id 2 could be assigned with row number 3 and the row with id 11 could be assigned with row number 2. So apparently the window order clause is mandatory for the ROW_NUMBER function in SQL Server.

Servers 104

Servers C++ Storage Performance 104

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Here’s the attempted solution using a CTE: WITH C AS. ( FROM Sales.

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name , [ Column ] = c. system_type_id <> c.

C++ 58

C++ Database Servers Performance 58

Testsigma

APRIL 23, 2021

Simform (as of 2019) stated that an average user has at least 40 apps installed on their phones while millennials have around 67 apps. It also supports the testing of native, hybrid, and mobile web apps across various programming languages like Java, Ruby, C#, Javascript, PHP, Python. Being open-source, it also has a rich community! .

Testing Tools 86

Testing Tools Mobile Testing Open Source 86

HammerDB

JUNE 27, 2022

Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub. HammerDB supports 2 workloads derived from TPC specifications to test these different requirements, namely TPROC-C derived from TPC-C for OLTP and TPROC-H derived from TPC-H for OLAP.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

The Morning Paper

JUNE 2, 2019

By getting pass/fail feedback from the CI server, the model can adapt to the test set used in the CI environment, leading to it overfitting over time. ci can integrate with an existing CI server (Travis in the implementation), and provides a DSL for specifying model tests. where c is large). Incremental quality improvement (F2).

C++ 60

C++ Strategy Testing Servers 60

Brendan Gregg

SEPTEMBER 25, 2021

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. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c. 30.14% in the middle of the flame graph. Try changing the kernel clocksource.

Speed 103

Speed Java AWS Virtualization 103

SQL Performance

JULY 1, 2019

The results are technically non-deterministic since SQL Server could validly return any one of the rows in each group. Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level.

C++ 58

C++ Servers Database Performance 58

Smashing Magazine

APRIL 9, 2019

2019-04-09T12:30:59+02:00. 2019-04-29T18:34:58+00:00. Most sites were all hosted on a single physical server somewhere on our own hosting infrastructure, and it was the server we thought about defending when it came to security best practices. file hosted as part of their own website on their own server.

Website 64

Website Servers Code Best Practices 64

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. is a server-side, open-source, JavaScript runtime environment that allows developers to write JavaScript on the client and the server-side.

Open Source 52

Open Source Virtualization Programming Servers 52

Tasktop

OCTOBER 16, 2019

That test was using one of our components to connect to a server, post some data, retrieve the data and assert that the new data is present. We run a lot of similar tests against myriad servers and even more versions of the aforementioned. Are we somehow hitting some edge case with certain unicode characters coming from the server?

C++ 9

C++ Servers Testing Infrastructure 9

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. SELECT DISTINCT c from sbtest where id between ? order by c. SELECT c from sbtest where id=? Copyright (C) 2003-2018 Steve Shaw.

Best Practices 40

Best Practices Scalability Performance C++ 40

Smashing Magazine

JANUARY 21, 2019

2019-01-21T13:00:21+01:00. 2019-04-29T18:34:58+00:00. This article was updated on January 31, 2019 to react to readers’ feedback. An API is the communication channel for an application to load data from the server. Leonardo Losoviz. Large preview ). This JSON object is already the response from the component-based API.

Social Media 73

Social Media Database Media Website 73

Brendan Gregg

SEPTEMBER 25, 2021

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). I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c In 2019 myself and others tested kvm-clock and found it was only about 20% slower than tsc.

Speed 52

Speed Java AWS Virtualization 52

The Morning Paper

SEPTEMBER 12, 2019

The Apache MADLib project is still going strong, and the recent (July 2019) 1.16 The implementations require both SQL and also some UDFs written in C++. Machine learning inside a relational database has been done before, most notably in the form of MADlib , which was integrated into Greenplum during my time at Pivotal.

Network 44

Network Database Programming Hardware 44

Brendan Gregg

SEPTEMBER 25, 2021

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. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c In 2019 myself and others tested kvm-clock and found it was only about 20% slower than tsc.

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

SEPTEMBER 25, 2020

However, the problem still exists in SQL Server 2019. a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. Here’s the only item I’ve found that made it to the new feedback system.). Really hard.

Code 42

Code C++ Database Servers 42

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. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

Percona

MARCH 7, 2019

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. There could be more, but this particular query was definitely hurting the performance of the server. 2019-02-22T18:26:25 Creating triggers. 2019-02-22T18:27:14 Created triggers OK.

C++ 111

C++ Traffic Servers Monitoring 111

Smashing Magazine

OCTOBER 26, 2018

2019-04-29T18:34:58+00:00. When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. If you decide to use the method described in this article, be sure you know how to fortify your server security.

Cache 88

Cache Website Speed Testing 88