SQL Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. On more than one occasion, I had to double-check the code was even mine. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. (

Servers 82

Servers Code Efficiency Performance 82

Speed Curve

FEBRUARY 21, 2021

As a developer I've always been fascinated by the web and how it enriches people's lives, and now I am jumping into the very essence of it – how it renders, performs and behaves! I started coding web pages in about 2005 and began my web development career in Moscow, Russia, joining a biotech startup. My background.

BioTech 72

BioTech Healthcare Network Development 72

SQL Performance

AUGUST 12, 2020

T-SQL supports it starting with SQL Server 2005. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. However, there are very few cases in T-SQL where without a terminator the code is ambiguous. The elements are sort of intertwined.

C++ 140

C++ Code Design Database 140

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). Building separate models for each of the benchmarks was required to get the correct asymptotic properties.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

SQL Performance

OCTOBER 9, 2019

Consequently, handling our task becomes a no-brainer: DECLARE @s AS VARCHAR ( 20 ) = '123.456.789,00' ; SELECT TRANSLATE ( @s , '.,' , ',' ) ; This code generates the desired output: 123,456,789.00. As an example, suppose that you need to perform some task per database in your instance. That's pretty neat!

C++ 111

C++ Database Servers Code 111

Smashing Magazine

DECEMBER 2, 2021

Advent of Code. If you prefer a puzzle over an article, take a look at Advent of Code. Good ol’ PerfPlanet is back for another season with all things speed and web performance. Code Security Advent Calendar. It launched in 2005 and still has all of the calendars available online. JavaAdvent on Twitter.

Design 110

Design Development Programming Website 110

Brendan Gregg

AUGUST 8, 2017

If they are higher than your CPU count, then you might have a performance problem (it depends). Nowadays, the source code to old operating systems can also be found online. Linux is also hard coding the 1, 5, and 15 minute constants. The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2,

Latency 111

Latency Metrics C++ Systems 111

SQL Performance

MARCH 29, 2022

Forced parameterization wasn’t added until SQL Server 2005, so Microsoft had the opportunity to incorporate some lessons from the simple parameterization experience, and didn’t have to worry much about backward-compatibility issues. Behaviours are maintained to avoid breaking legacy code. The next step involves the arithmetic operator.

Cache 90

Cache Servers Database Testing 90

Sutter's Mill

DECEMBER 29, 2011

From 1975 to 2005, our industry accomplished a phenomenal mission: In 30 years, we put a personal computer on every desk, in every home, and in every pocket. In 2005, however, mainstream computing hit a wall. The free lunch is over. Now welcome to the hardware jungle. iPad 2, Playbook, Kindle Fire, Nook Tablet) and smartphones (e.g.,

Hardware 40

Hardware Games Operating System Software 40

SQL Performance

JULY 1, 2021

These types are on the deprecated list for many reasons, and have held a permanent spot on that list since being replaced by the max types way back in SQL Server 2005. t2 ( id bigint IDENTITY PRIMARY KEY , msg ntext ) ; Now, let's try to perform online operations on the tables: ALTER TABLE dbo. CREATE TABLE dbo. Conclusion.

C++ 58

C++ Database Servers Performance 58

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. Still, you should write code with both close to the front of your mind. For legacy applications or other third-party code that cannot be easily changed, explicit parameterization may not always be possible. Shell Plans. EXECUTE sys.

Cache 61

Cache Servers Database Code 61

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Brendan Gregg

JUNE 3, 2021

It was 2005, and I felt like I was in the eye of a hurricane. I was an independent performance consultant and Sun Microsystems had just released DTrace, a tool that could instrument all software. This gave performance analysts like myself X-ray vision. You can't make this stuff up. DTraceToolkit v0.96 They were useful, but.I

Open Source 40

Open Source Code Engineering Technology 40

IO River

NOVEMBER 2, 2023

‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. This means that if you wish to switch CDN, you’d have to rewrite a vast amount of code to support a new API.‍‍Sign Akamai tried to convince many users to use this new framework.

Lambda 52

Lambda AWS Cache Website 52

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

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

IO River

NOVEMBER 2, 2023

You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. However, the IaC code significantly changes across each CDN provider.For example, the IaC code to provision a CloudFlare CDN and a CloudFront CDN is different in any IaC provider.

Lambda 40

Lambda AWS Cache Website 40

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

Smashing Magazine

MAY 17, 2021

Performance is a core feature of our company, Instant Domain Search —it’s in the name. I founded Instant Domain Search in 2005 and kept it as a side-hustle while I worked on a Y Combinator company (Snipshot, W06), before working as a software engineer at Facebook. When paired with VS Code the development experience is amazing.

Google 96

Google Analytics Serverless Metrics 96

SQL Server According to Bob

DECEMBER 18, 2018

Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The “forced flush” changes in SQL Server avoid flushes, when possible, in order to improve performance on non-optimized Fua file systems. Performance points of reference: The following charts highlight the increase in performance.

Servers 90

Servers Media Cache Storage 90

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. When maintenance is needed, it won’t take the team as long to maintain the code because of accessibility and clean code.”.

Website 145

Website Mobile Design Testing 145