Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills. This post explores why this happens, how to identify it, and some quick tips to optimize your queries.What Causes TempDB Spills?Tempdb spills occur when SQL Server does not allocate enough memory for operations like sorting. The spill results in SQL Server writing intermediate data to tempdb, which introduces additional I/O overhead. Here’s an example scenario:The sort operator processes over 121,317 rows, but SQL Server grants only 6,000 KB of memory.Insufficient memory causes the operation to spill, leading to:460 pages written to tempdb.Approximately 10…
Author: drweb
Have you ever tried examining the size of an entire Angular project and comparing it to the size of the code compiled by Angular (its build output in the dist folder)?The difference is almost hard to believe. Typically, the entire project folder of an Angular app is well above 600MB, which includes a lot of things, including your code, all your dependencies, but also the Angular CLI, the TypeScript compiler, and more:After running ng build, your dist folder is much smaller than 600MB, usually just a few KB or MB, depending on the size of your application.This is because of…
Not all of this is like absolutely brand spanking new just-dropped-in-2024 stuff. Some of it is, but generally it’s relatively new stuff that’s all pretty great. I’m pointing things out that I think are really worth knowing about. It’s possible you haven’t kept up too much with HTML developments as it tends to, rightfully, move a lot slower than CSS or JavaScript. A group of details elements can behave like an accordion, among other improvements, but still have accessibility limitations. We’ve had cross-browser / support since 2016, but only recently have the abilities started to expand and clean up. For…
Welcome to the October edition of PHP Annotated! This recap is carefully handcrafted and brings you the most interesting developments in the PHP community over the past couple of months, so you don’t have to sift through the noise—we’ve done it for you. @media (min-width: 769px) { main .article-section .content ul:not([class]):not([id]) li ul:not([class]):not([id]) { margin-top: 0; margin-bottom: 24px; } } main .article-section .content ul:not([class]):not([id]) li, main .article-section .content ul:not([class]):not([id]) > li {padding-bottom: 18px;} main .article-section .content ul:not([class]):not([id]) li ul:not([class]):not([id]) li {padding-bottom: 0;} img.alignico {margin-right: 10px;margin-top: 5px;float: left;} summary {display: list-item;cursor: pointer;font-style: italic; } section.article-section a {color: #7755f3} code {color: red;}…
I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things I didn’t show from my own database was that it had no FKs, so the subsetting didn’t quite work as I wanted.A previous post showed how add starting tables for the subsetter to look at, however that didn’t get me a good data set for testing. This post continues looking at the subsetter by adding manual relationships to our configuration.This is part of a series of posts on TDM. Check out…
Do you write React Native or JavaScript articles and want to be featured in our blog? Reach out to wyatt@reactnativecoach.com and we’ll review your submission. ✌🏻Learn how to release your app on the Google Play store with another great tutorial from Gant Laborde.Nice post here from Gunnari Auvinen on how to debug React Native and Redux with React Native Debugger.Learn how to create a polyline with react-native-maps with this article from Ravish Rawal.Nice writeup here from Robert Vogt on how his team shares code between React Native and React.Another great post from Spencer Carli on how to get up and…
Difference Between Bitwise and Logical Operators in PHP The distinction between bitwise operators and logical operators operators is often overlooked and confused. They are often used one for another: it is true they have some overlapping domains of application, and yet, their functionality differ significantly. Here’s a breakdown of how these operators work: Logical Operators: Booleans at Play Logical operators in PHP operate on boolean values and return boolean results. For example: These operators are often represented using integers, specifically 0 and 1, where 0 is equivalent to false and 1 is equivalent to true. Consider the following example: Under…
Execution timeout in SSMS are a small but important feature that can help you manage query performance. By default, SSMS allows queries to run indefinitely, but there are times when limiting execution time can prevent issues in both testing and production environments. In this post, we’ll explore why and how to adjust execution timeouts and their practical use cases.Why Adjust Execution Timeouts?Testing QueriesWhen testing or troubleshooting, you may not want queries to run longer than necessary. A timeout ensures they don’t consume resources endlessly.Production SystemsOn live systems, long-running queries can block other operations and degrade performance. Limiting execution time protects…
Do you write React Native or JavaScript articles and want to be featured in our blog? Reach out to wyatt@reactnativecoach.com and we’ll review your submission. ✌🏻Great start of a series from Antoine Hanriat on high performance animations with scroll behaviors.Awesome set of animations done in React Native with source code from GeekyAnts.Great article on Error Boundaries in React/React Native from Bene Studio.Great article on how React & React Native handle events, from Nicolas Couvrat.Learn how to deliver push notification with Firebase Cloud Functions with this tutorial from Alexi Christakis.Allow the user to choose the maps app of their choice with…
IT transformations are often framed as rapid revolutions, but in reality, they unfold as decades-long evolutions. Consider cloud deployments: It dominated industry conversations 15 years ago, but only now several organizations are finalizing their migrations. Similarly, blockchain emerged with much fanfare, but its broader use cases beyond cryptocurrencies are just beginning to materialize. The same principle applies to DevOps — and, by extension, DevSecOps. The Promise of DevOps and the Reality of its Evolution DevOps was heralded as a cultural and operational shift, promising to dismantle silos between developers and operations teams, fostering collaboration and accelerating software delivery. While the concept holds…