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

Rigor

JANUARY 13, 2020

The in-depth explorations are meticulously illustrated and code examples culminate as bulletproof code snippets, applicable to your work right away. You only have a few seconds to get compelling content onto the screen. Fail, and you can kiss your customers and profits goodbye.” ” – Andy King, 2003. Using Webpagetest.

Performance 75

Performance Social Media Website Website Performance 75

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.

Java 137

Java Cache Google Hardware 137

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

Smashing Magazine

DECEMBER 2, 2021

Advent of Code. If you prefer a puzzle over an article, take a look at Advent of Code. Code Security Advent Calendar. If you’re up for a challenge that involves spotting security vulnerabilities, then the Code Security Advent Calendar is just the right one for you. JavaAdvent on Twitter. LeanUXmas on Twitter.

Design 110

Design Development Programming Website 110

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. That's pretty neat! TRIM is more than LTRIM(RTRIM()). SQL Server 2017 introduced support for the function TRIM. Close the cursor.

C++ 111

C++ Database Servers Code 111

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

Tim Kadlec

FEBRUARY 18, 2008

Let’s say you have a calendar of events, and all you want to retrieve all the events that occurred between 2005 and 2007. Getting all the year spans where the value is between 2005 and 2007 is easy. >=2005 and. We can simply do this: //span[@class="year"][.

Code 40

Code Testing Development 40

Brendan Gregg

AUGUST 8, 2017

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. This state is used by code paths that want to avoid interruptions by signals, which includes tasks blocked on disk I/O and some locks. This, too, was a dead end. This, too, was a dead end.

Latency 111

Latency Metrics C++ Systems 111

Adrian Cockcroft

JANUARY 31, 2023

I got interested in programming mobile phones, and at the time, in 2005, the built-in email app on the Blackberry was state-of-the-art. I remember telling Eric “I just wrote 1000 lines of code in a language no-one’s really used in 25 years to build this actor based simulator, and it works!”, and he thought it was cool.

Google 52

Google Transportation Programming Innovation 52

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

Particular Software

MARCH 11, 2020

StructureMap and Castle Windsor were released in 2004, Spring.NET in 2005, and more after that, each with their own unique API, some more opinionated than others. The history of dependency injection (DI) containers in.NET is almost as long as.NET itself.

Strategy 52

Strategy Engineering Code Software 52

SQL Performance

MARCH 22, 2022

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. You may be able to overcome some obstacles using template plan guides. Shell Plans. EXECUTE sys. sp_configure. DisplayName.

Cache 61

Cache Servers Database Code 61

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

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. My mind started racing about these older data types to explain why we really shouldn't be using them anymore: image ntext text. name , [ Object ] = o. user_type_id.

C++ 58

C++ Database Servers Performance 58

SQL Server According to Bob

JUNE 3, 2016

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. For example, the improved compression capabilities applied to AlwaysOn are being tested and evaluated for use by the Backup/Restore code line. Table of Contents.

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. Another difference was that there were few roles in Australia for engineers in 2005, unlike the US. But I _did_ understand these tools, since I had coded similar functionality for my own DTraceToolkit. You can't make this stuff up. They were useful, but.I

Open Source 40

Open Source Code Engineering Technology 40

IO River

NOVEMBER 2, 2023

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 For example, Akamai introduced ASI in 2005, which became the standard for building new websites. Therefore, if you wish to migrate across different CDNs, you’ll have to rewrite the IaC code almost entirely.Â

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. I already had Google Analytics installed, so I added the following code to each page. I may have lured you in with the false pretence of saving the environment….but

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. I already had Google Analytics installed, so I added the following code to each page. I may have lured you in with the false pretence of saving the environment….but

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. I already had Google Analytics installed, so I added the following code to each page. I may have lured you in with the false pretence of saving the environment….but

Energy 40

Energy Cache Traffic Website 40

IO River

NOVEMBER 2, 2023

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 03 - Over-relying on vendor-specific functionalitySome CDN providers offer unique and specialized features that are unavailable to their competitors. Akamai tried to convince many users to use this new framework.

Lambda 40

Lambda AWS Cache Website 40

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. No focus groups, no research, no audience testing, just a gutsy and intuitive design decision. 50 ⁄ 50 Image To Text. Agneta Darin.

Design 79

Design Media Website Speed 79

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

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. This is a screenshot from our mobile Core Web Vitals report in Google Search Console.

Google 96

Google Analytics Serverless Metrics 96

SQL Server According to Bob

DECEMBER 18, 2018

Before all was said and done, all of these people and more helped with various activities: · Eugene, Mike, Slava, Scott, Peter, Steve and others doing code reviews on my SQL Server and Host Extension changes. · Red Hat, SUSE, HPE, Intel helping and confirming Linux behaviors and making file system code changes. File Integrity Standard.

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

Dynatrace

OCTOBER 10, 2024

We have detailed the launch of our Dynatrace Culture Code. This one piece of Dynatracer feedback captures the environment and culture we’ve carefully curated since the company’s founding in 2005. Now, it’s time to reflect on how we continue to build the Dynatrace Employer Brand. There is a sense of belonging here.”

Best Practices 189

Best Practices Code Design Speed 189