SQL Performance

AUGUST 1, 2022

Both functions were, and at the time of writing still are, available only as window functions. If you’re using T-SQL to compute percentiles as part of your work, these functions should be familiar to you since they’ve been supported in SQL Server 2005 and later. 75 Test XYZ Student C 55 Test XYZ 77.5

Servers 142

Servers Testing C++ Code 142

SQL Performance

FEBRUARY 22, 2021

The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections. I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us.

Latency 57

Latency Servers Monitoring Systems 57

Testsigma

MAY 16, 2020

According to an article published by smallbizgenius , in 2019, the number of people who work from home has increased by 140% since 2005. They also won’t know if you are available or not. Remote work has been steadily gaining popularity for some years now. Now, most of the population is working from home. Communicate this beforehand.

Social Media 61

Social Media Media Website Testing 61

Brendan Gregg

JUNE 3, 2021

It was 2005, and I felt like I was in the eye of a hurricane. Another difference was that there were few roles in Australia for engineers in 2005, unlike the US. So back then in Australia you could find amazing engineers doing whatever roles were available. You can't make this stuff up.

Open Source 40

Open Source Code Engineering Technology 40

Smashing Magazine

DECEMBER 2, 2021

The project is available in twenty languages, and encourages all kinds of contributions to open-source projects — including non-pull-request contributions. It launched in 2005 and still has all of the calendars available online. 24 Pull Requests. 24ways on Twitter.

Design 107

Design Development Programming Website 107

Daniel Lemire

FEBRUARY 8, 2019

In some instances, libdivide can even be more efficient than compilers because it uses an approach introduced by Robison (2005) where we not only use multiplications and shifts, but also an addition to avoid arithmetic overflows. I make my benchmarking code available. What if d is a constant, but not known to the compiler?

C++ 279

C++ Benchmarking Hardware Testing 279

SQL Server According to Bob

JANUARY 11, 2020

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40

Servers Cache Database Media 40

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth.

Java 145

Java Cache Google Hardware 145

Smashing Magazine

JULY 9, 2021

The British Standards Institution (2005) defines inclusive design as : “The design of mainstream products and/or services that are accessible to, and usable by, as many people as reasonably possible. without the need for special adaptation or specialized design.”. Recording the training and who and when it was completed.

Website 145

Website Mobile Design Testing 145

KeyCDN

MARCH 28, 2019

There are a myriad of options available when choosing which backend framework you want to work with. Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005.

Programming 77

Programming Website Scalability Design 77

SQL Performance

JANUARY 23, 2020

Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. Detailed query-level waits are available on demand via integrated Plan Explorer.

Tuning 115

Tuning Servers Monitoring Hardware 115

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Server According to Bob

DECEMBER 18, 2018

CSA ISO/IEC 9945-1:2005 (R2009) 3.375 Synchronized I/O Data Integrity Completion. Refer to the ISO documentation on file integrity for complete details: CSA ISO/IEC 9945-1:2005 (R2009) 3.376 Synchronized I/O File Integrity Completion. Filesystem Type 1K-blocks Used Available Use% Mounted on. File Integrity Standard. O_NONBLOCK.

Servers 90

Servers Media Cache Storage 90

IO River

NOVEMBER 2, 2023

For example, Akamai introduced ASI in 2005, which became the standard for building new websites. Specialized featuresSome vendors offer specialized features that are not available in competing CDNs. Akamai tried to convince many users to use this new framework. If the CDN fails, your application fails.‍If

Lambda 52

Lambda AWS Cache Website 52

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

SQL Performance

MARCH 30, 2021

The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. The reservation guarantees SQL Server will remain around its configured maximum number of threads at all times, but the physical thread may not be immediately available from the thread pool.

Cache 98

Cache Servers Operating System Processing 98

The Agile Manager

JANUARY 31, 2016

The ecosystem strategy takes this even further, combining unrelated capabilities under one roof (eBay buying Skype in 2005, SAP developing HANA in 2010, Facebook buying Oculus in 2014), often justifiable if only because digital commerce is still in its infancy and nobody is really sure what's going to work and what's not.

Blockchain 40

Blockchain Retail Social Media Airlines 40

SQL Performance

AUGUST 12, 2020

T-SQL supports it starting with SQL Server 2005. In logical query processing terms, by the time you get to the outer query, the CTE name is already defined and available. Similarly, a table expression returns a table and is supposed to be available as an input table for another table expression.

C++ 140

C++ Code Design Database 140

IO River

NOVEMBER 2, 2023

So, when businesses integrate these exclusive features into their applications, they become tied to the vendor, as replicating these features in another CDN is impossible.‍For example, Akamai introduced ASI in 2005, which became the standard for building new websites. Akamai tried to convince many users to use this new framework.

Lambda 52

Lambda AWS Cache Website 52

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006.

Virtualization 40

Virtualization AWS Hardware Storage 40

Highly Scalable

MARCH 10, 2015

This approach can be expressed in more formal way by the following equation: where is the data available for analysis, is the space of a retailer’s actions and decisions, is an econometric model defined as a function of actions and data, and is the optimal strategy. This framework resembles the approach suggested in [JK98].

Retail 152

Retail C++ Analytics Metrics 152

The Agile Manager

MAY 7, 2010

A contract from 2005 between one firm and another is a binding legal document in the context of that relationship. One example is FlightCaster , which applies complex analytics on publicly available data (such as the weather, and current flight status and historical flight data) to advise whether you should switch flights or not.

Storage 40

Storage Internet Internet Mobile 40

Brendan Gregg

AUGUST 8, 2017

The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2, Hoping to take a shortcut, I dumped "git log -p" for the entire Linux github repository, which was 4 Gbytes of text, and began reading it backwards to see when the code first appeared. This, too, was a dead end.

Latency 111

Latency Metrics C++ Systems 111

Smashing Magazine

OCTOBER 3, 2019

The result was a cover which went on to win the New York Art Director's Club medal and was placed at number fifteen in the American Society of Magazine Editor’s 2005 list of Top 40 Magazine Covers. Filters in SVG offer far greater flexibility with six more filters available and incredible customization possibilities. Agneta Darin.

Design 76

Design Media Website Speed 76