Sites anglophones


5 Ways to Change Execution Plans Without Tuning

Publié le 21 décembre 2018 sur brentozar.com
 

A couple years back, I realized there were at least Ten Ways to Set MAXDOP. These days, as I write and tune queries, I realize there are an awful lot of ways to change the Cardinality Estimator (CE) and Query Optimizer, too. Let’s take a quick su …

SQL Provision offers users an easier way to manage, organize and make available masked copies of databases

Publié le 21 décembre 2018 sur sqlservercentral.com
 

Over the past year Redgate has released some major improvements to SQL Provision, including the ability to modify images with Data Masker and SQL scripts, and create templates for clones, allowing users to specify SQL scripts to run after creation.

Understanding Peer-to-Peer Transactional Replication, Part 1

Publié le 21 décembre 2018 sur sqlservercentral.com
 

There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls. How to fix SQL Se …

Disable Data Sync for SQL Server Merge Replicated Table via Publisher

Publié le 21 décembre 2018 sur sqlservercentral.com
 

Learn how to stop the data sync process in SQL Server Merge Replication on a large table during maintenance windows.

SQL SERVER – How to Write Correlated Subquery?

Publié le 21 décembre 2018 sur journey to sqlauthority
 

This is a follow-up blog post to my earlier blog post written about SQL SERVER – Writing Your First Subquery From a Single Table. In the blog post, we discuss how to write a correlated subquery and why it is actually necessary. In …

Do Functions Stop You From Using Indexes?

Publié le 20 décembre 2018 sur brentozar.com
 

Say I’ve got a function in my WHERE clause:SELECT DisplayName FROM dbo.Users WHERE LTRIM(RTRIM(DisplayName)) = ‘Brent Ozar’; If I have an index on DisplayName, will SQL Server use it? Sure: Function in the WHERE clause Even though SQL Server can …

Removing Extended Properties

Publié le 20 décembre 2018 sur sqlservercentral.com
 

With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.

4 Online SQL Server Help Resources for DBAs ('Accidental' and Otherwise)

Publié le 20 décembre 2018 sur sqlmag.com
 

There are several good online SQL Server options DBAs can turn to for advice, support and help.

SQL SERVER – Writing Your First Subquery From a Single Table

Publié le 20 décembre 2018 sur journey to sqlauthority
 

My primary responsibility is to help different organizations with tuning their SQL Server Performance and here is the link to my most popular service SQL Server Performance Health Check. I often encounter complicated performance problems which are …

Performance and Stability Related Fixes in Post-SQL Server 2014 SP3 Builds

Publié le 19 décembre 2018 sur sqlskills.com - glen berry
 

As of December 12, 2018, there has been one Cumulative Update (CU) for the Service Pack 3 branch of SQL Server 2014. There were a relatively large number of hotfixes in this first cumulative update. If you are running on the SQL Server 2014 SP3 branch, …

SQL Server 2014 Service Pack 3 CU1 Released

Publié le 19 décembre 2018 sur sqlskills.com - glen berry
 

On December 12, 2018, Microsoft released SQL Server 2014 Service Pack 3 CU1, which is Build 12.0.6205.1. There are 13 hotfixes in the public fix list. If you are running SQL Server 2014, you should be planning on getting on the SP3 branch as soon as po …

Query Store And Cruel Defaults

Publié le 19 décembre 2018 sur brentozar.com
 

Gosh Darn Now, look, it’s no secret that I think Query Store is cool. Heck, I went and wrote sp_BlitzQueryStore so you can examine it similarly to how sp_BlitzCache looks at the plan cache. For a variety of reasons, though, we run into peopl …

SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files Cannot be Fewer than 2

Publié le 19 décembre 2018 sur journey to sqlauthority
 

Since I wrote my article about the script of shrinking the Log Files, there have been many emails from my blog readers about various messages which they are seeing during shrink. I have been sharing them with other blog readers as well. In this blog, w …

SSRS Reporting Basics: When is SSRS the Right Tool?

Publié le 18 décembre 2018 sur simple-talk.com
 

SQL Server Reporting Services (SSRS) is a server-based reporting tool, ideal for paginated reports. It represents a centralized approached to data governance, with all of your report files located on a central server. However, there are some self-servi …

Sniffed Nulls and Magic Numbers

Publié le 18 décembre 2018 sur brentozar.com
 

I Sniff Your Milkshake Building off of A Simple Stored Procedure Pattern To Avoid, I wanted to talk about a similar one that I see quite often that is not nearly as clever as one would imagine. I goes something like this: If this variable is passed in …


Pages :