article thumbnail

Scalar UDF Inlining in SQL Server 2019

SQL Shack

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107
article thumbnail

tempdb Enhancements in SQL Server 2019

SQL Performance

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95
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

Which Is the Best PostgreSQL GUI? 2019 Comparison

Scalegrid

You can remotely access and navigate another database server. The dashboard lets you monitor server activities such as database locks, connected sessions, and prepared transaction. Since pgAdmin is a web application, you can deploy it on any server and access it remotely. 2019 Comparison Click To Tweet.

article thumbnail

Web Development Trends 2019

KeyCDN

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. It can be used to decouple your frontend from your backend and improve server efficiency.

article thumbnail

SQL Server On Linux: Logger.ini Size and Rollover Additions to SQL Server 2019 CU4

SQL Server According to Bob

SQL Server On Linux: Logger.ini Size and Rollover Additions ​​ to SQL Server 2019 CU4 I can’t take credit for this post as Dylan added the code and provided the write-up to share with you. For SQL Server on Linux, there are ​​ additional logging capabilities.

Servers 40
article thumbnail

Improving JavaScript Bundle Performance With Code-Splitting

Smashing Magazine

Improving JavaScript Bundle Performance With Code-Splitting. Improving JavaScript Bundle Performance With Code-Splitting. It’s a common misconception that the code which is produced by the framework build tools (Webpack, for example) is fully optimized and cannot be improved upon any further. The answer lies in code-splitting.

Code 89
article thumbnail

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. ( SELECT TOP ( 9223372036854775807 ) *.

C++ 140