article thumbnail

Fundamentals of Table Expressions, Part 12 – Inline Table-Valued Functions

SQL Performance

I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. CREATE INDEX idx_nc_cid_odD_oidD_i_eid ON Sales.

Cache 144
article thumbnail

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]

Smashing Magazine

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. Ad Weight Impact If your site depends on the revenue generated by advertising, it’s useful to track the weight of ad related code.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Increase the Performance of your Site with Lazy-Loading and Code-Splitting

Jos

We are explicit about our dependencies, so we know what code we need to run to run a specific component. Lazy-loading and bundle splitting can have a huge impact on page performance: less code requested, parsed, and executed. When you send the user code that is not needed, you waste resources from your end, and from the user’s end.

Code 130
article thumbnail

Optimizing Google Fonts Performance

Smashing Magazine

2019-06-20T11:00:16+02:00. 2019-06-20T10:35:07+00:00. Browser Caching. Another built-in optimization of Google Fonts is browser caching. As the Google Fonts API becomes more widely used, it is likely visitors to your site or page will already have any Google fonts used in your design in their browser cache.

Google 111
article thumbnail

What is? OpenTelemetry??An open-source standard for logs, metrics, and traces

Dynatrace

Here are the steps the solution takes, and the data it generates along the way: Instruments your code with APIs, telling system components what metrics to gather and how to gather them. This occurs once data is safely stored within a local cache. This makes it easy to switch backends without the pain of re-instrumenting your code.

article thumbnail

Simple Parameterization and Trivial Plans — Part 1

SQL Performance

In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. 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.

Cache 61
article thumbnail

Simple Parameterization and Trivial Plans — Part 2

SQL Performance

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. DisplayName.

Cache 90