Remove 2019 Remove Cache Remove Code Remove Servers
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. Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

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

When Do SQL Server Sorts Rewind?

SQL Performance

Its raison d’être is to cache result rows from a plan subtree, then replay those rows on subsequent iterations if any correlated loop parameters are unchanged. Table-valued functions use a table variable, which can be used to cache and replay results in suitable circumstances. Spools are the least costly way to cache partial results.

Servers 106
article thumbnail

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. 4 Socket, TPCC.

Servers 90
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. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.

Cache 90
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. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. Still, you should write code with both close to the front of your mind. Simple Parameterization.

Cache 61