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. The most fatal flaw in the code above is it leaves a trailing comma: UserID Bands.

Servers 82

Servers Code Efficiency Performance 82

Brendan Gregg

MARCH 16, 2024

Apart from library code, maybe your application doesn't have frame pointers either, in which case everything is broken. 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. Back-end servers.

Java 145

Java Cache Google Hardware 145

Smashing Magazine

MAY 17, 2021

Last year, Google started emphasizing the importance of Core Web Vitals and how they reflect a person’s real experience when visiting sites around the web. It wasn’t long before a sea of red “poor” and yellow “needs improvement” notices in our Google Search Console needed our attention. How We Improved Our Core Web Vitals (Case Study).

Google 93

Google Analytics Serverless Metrics 93

Rigor

JANUARY 13, 2020

Take, for example, The Web Almanac , the golden collection of Big Data combined with the collective intelligence from most of the authors listed below, brilliantly spearheaded by Google’s @rick_viscomi. You only have a few seconds to get compelling content onto the screen. Fail, and you can kiss your customers and profits goodbye.”

Performance 75

Performance Social Media Website Website Performance 75

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40