DAX for SQL Folks: Part II – Translating SQL Queries to DAX Queries
Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning ex …
Right-Sizing Row Mode Query Memory Requirements
In older versions of SQL Server (prior to SQL Server 2019, aka 15.x), SQL Server memory grant feedback supported was added, but only for batch mode queries. Queries that use batch mode performing scanning and calculations on up to 900 rows at a time, v …
Implementing a Data Quality Monitoring Framework
I. Introduction Data Quality is imperative to the success of any Business Intelligence solution. In today’s era, where the data is being ingested from multiple sources, the quality of the data might differ between sources. The first step to a suc …
If You Have Foreign Keys, Don’t Update Fields That Aren’t Changing.
If you update a row without actually changing its contents, does it still hurt? Paul White wrote in detail about the impact of non-updating updates, proving that SQL Server works hard to avoid doing extra work where it can. That’s a great post, a …
SQL Server 2019 New Performance Features
The post SQL Server 2019 New Performance Features appeared first on SQLServerCentral.
Storage 101: Modern Storage Technologies
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …
Free Webcast Today: How to Measure Your SQL Server
If you get into a car, how do you know if the car is fast or not? You hold down the gas pedal, and you time how long it takes before you’re breakin’ the law. Now what about SQL Server: how do you know if yours is fast…or a clunker? D …
Your First Pipeline with Azure Data Factory
If you’re new to Azure Data Factory (ADF), it can be difficult to know where to start. Even if you have some experience with SSIS, everything in ADF looks both familiar and different at the same time! In this article I step through creating a bas …
How to Get Better Estimates for Modification Queries
When you’re doing DUI operations against tables with millions of rows, you have to be really careful about SQL Server’s estimates. Ideally, you want your delete/update/insert (what – what’d you think I meant?) queries to be as s …
A Pattern Based Approach to Masking Errors
A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” wa …
SQL Monitor Roadtrip: Preparation
The post SQL Monitor Roadtrip: Preparation appeared first on SQLServerCentral.
Creating or Altering an Objects with a Single Statement
The post Creating or Altering an Objects with a Single Statement appeared first on SQLServerCentral.
[Video] Can You Tell When a Rollback Will Finish?
I happened to see this DBA.StackExchange.com question about killing a big delete, and I really felt for the admin involved: Four days ago a user ran the command below on a table with 400,000,000 rows. It’s still running and the log file is increa …
What Percent Complete Is That Index Build?
The post What Percent Complete Is That Index Build? appeared first on SQLServerCentral.
A Set-based Solution for the Bin Packing Problem
Introduction The Bin Packing Problem, in its simplest form, is easy to explain and to understand: imagine that there are a certain number of items, each one with its own value (e.g. a volume, a weight, a length…) and an infinite number of bins i …