article thumbnail

SQL Server 2017 Improved Resource Usage On Smaller Machines

SQL Server According to Bob

SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. For SQL Server 2017 CU4 the small environment threshold is 2GB. What Is A Small System?

Servers 40
article thumbnail

T-SQL bugs, pitfalls, and best practices – pivoting and unpivoting

SQL Performance

The main benefit of the PIVOT operator is that it tends to result in shorter code. However, this operator has a few shortcomings, among them an inherent design trap that can result in bugs in your code. You can find a clue that will help you figure out the bug in the code by looking at the query plan shown in Figure 1.

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

Towards federated learning at scale: system design

The Morning Paper

Towards federated learning at scale: system design Bonawitz et al., FL is one instance of the more general approach of “bringing the code to the data, instead of the data to the code” and addresses the fundamental problems of privacy, ownership, and locality of data. SysML 2019. ” Secure Aggregation.

Systems 71
article thumbnail

NULL complexities – Part 1

SQL Performance

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. For the most part, SQL was designed to assume that NULLs represent the Missing But Applicable kind of missing value.

article thumbnail

T-SQL bugs, pitfalls, and best practices – window functions

SQL Performance

Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. Either as a fast in-memory spool that was especially designed for window functions, or as a slow on-disk spool, which is essentially a temporary table in tempdb. 2017-07-04 10248 440.00 OrderValues.

article thumbnail

Intellectual debt: The hidden costs of machine learning

Dynatrace

Even small amounts of technical debt compound as new code branches from old, further embedding the shortcomings into the system. Technical Debt—Dilbert Comic Strip on 2017-01-03. The sudden lure of artificial intelligence (AI) and machine learning (ML) systems designed for IT brings new urgency to the topic of intellectual debt.

article thumbnail

A Brief Guide of xPU for AI Accelerators

ACM Sigarch

BPU: Brain Processing Unit is the design of the AI chips by Horizon Robotics. They unveiled their first two embedded AI chips fabricated with TSMC 40nm process in December 2017: “Journey 1.0 With its modular architecture, DLA is scalable, highly configurable, and designed to simplify integration and portability.