Sites anglophones


DAX for SQL Folks: Part II – Translating SQL Queries to DAX Queries

Publié le 30 avril 2020 sur sqlservercentral.com
 

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

Publié le 29 avril 2020 sur simple-talk.com
 

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

Publié le 29 avril 2020 sur simple-talk.com
 

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.

Publié le 29 avril 2020 sur brentozar.com
 

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

Publié le 29 avril 2020 sur sqlservercentral.com
 

The post SQL Server 2019 New Performance Features appeared first on SQLServerCentral.

Storage 101: Modern Storage Technologies

Publié le 28 avril 2020 sur simple-talk.com
 

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

Publié le 28 avril 2020 sur brentozar.com
 

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

Publié le 28 avril 2020 sur sqlservercentral.com
 

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

Publié le 27 avril 2020 sur brentozar.com
 

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

Publié le 27 avril 2020 sur sqlservercentral.com
 

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

Publié le 27 avril 2020 sur sqlservercentral.com
 

The post SQL Monitor Roadtrip: Preparation appeared first on SQLServerCentral.

Creating or Altering an Objects with a Single Statement

Publié le 24 avril 2020 sur sqlservercentral.com
 

The post Creating or Altering an Objects with a Single Statement appeared first on SQLServerCentral.

[Video] Can You Tell When a Rollback Will Finish?

Publié le 23 avril 2020 sur brentozar.com
 

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?

Publié le 23 avril 2020 sur sqlservercentral.com
 

The post What Percent Complete Is That Index Build? appeared first on SQLServerCentral.

A Set-based Solution for the Bin Packing Problem

Publié le 23 avril 2020 sur sqlservercentral.com
 

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 …


Pages :