Sites anglophones


How Much Can One Row Change A Plan, Part 4

Publié le 19 janvier 2018 sur brentozar.com
 

Monte Carlo Or Bust In Part 3, I showed you how two queries with TOP clauses can produce wildly different plans. To figure some stuff out about why the plans changed, let’s focus on the Nested Loops Join plan. Why? Because when I force the Hash J …

A new home for my SQLBlog content…

Publié le 19 janvier 2018 sur sqlblog.com
 

I’ve moved my content over to sqlblog.org . Read more details……(read more)

How to identify blocking in SQL Server

Publié le 19 janvier 2018 sur sqlservercentral.com
 

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes.

Keeping track of history: SQL Compare and Temporal Tables

Publié le 19 janvier 2018 sur sqlservercentral.com
 

SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for tha …

Data Quality Components for SQL Server

Publié le 19 janvier 2018 sur sqlmag.com
 

Sponsored by: Melissa

SQL Server Intergration Services

Publié le 19 janvier 2018 sur sqlmag.com
 

Sponsored by: Melissa

SQL SERVER – How to Make SQL Server GDPR Compliance?

Publié le 19 janvier 2018 sur journey to sqlauthority
 

I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union. It is qui …

Checking Your SQL Server Instance for Spectre/Meltdown Patches

Publié le 18 janvier 2018 sur sqlskills.com - glen berry
 

If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems from the Meltdown and Spectre vulnerabilities. Microsoft has a number of KB articles that address this issue from …

How Much Can One Row Change A Plan, Part 3

Publié le 18 janvier 2018 sur brentozar.com
 

All The Rage We’ve asked how much one column and even one row can change a plan before. The doctor says I’m not allowed to read blog comments anymore on account of my blood pressure, but the AI I wrote in PowerShell assures me the …

Formatted ASCII Results from a SELECT

Publié le 18 janvier 2018 sur sqlservercentral.com
 

Generate aligned output from SELECT statement for code comments using a simple stored procedure.

Finding code smells using SQL Prompt: old-style join syntax

Publié le 18 janvier 2018 sur sqlservercentral.com
 

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax – here’s how it works.

SQL SERVER – Activity Monitor – Active Expensive Queries

Publié le 18 janvier 2018 sur journey to sqlauthority
 

Recently during Comprehensive Database Performance Health Check, I had a fascinating conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. …

[Video] The Junior DBA Workout Plan

Publié le 17 janvier 2018 sur brentozar.com
 

Squat, deadlift, overhead press, and bench press. In the gym, it’s easy to figure out what you need to be doing to get stronger. When you show up to work, you’re overwhelmed by all the things happening on your server(s), and you can’t …

Stairway to MDX – Level 5: Members, and an Introduction to the MDX Members Functions

Publié le 17 janvier 2018 sur sqlservercentral.com
 

Bill explains what is meant by a ‘Member’ and ‘Member function’ in MDX. A member is an item in a dimension that include the ‘measures’ which are the values of the attributes that belong to a dimension. ‘Measures’ are themselves members of a dimension c …

SQL SERVER – Performance Observation of TRIM Function

Publié le 17 janvier 2018 sur journey to sqlauthority
 

Earlier I wrote a blog post about how to remove leading and trailing spaces with TRIM function. SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function? After writing this blog post lots of people asked me …


Pages :