Sites anglophones


First Responder Kit Release: Fingers Crossed!

Publié le 2 octobre 2018 sur brentozar.com
 

This is a small release just to make sure you don’t forget about us. We know you’re busy. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements#1755 – @MisterZeus added a new check for aler …

Unused Indexes – Are they really unused or have they just not been used YET?

Publié le 2 octobre 2018 sur brentozar.com
 

During our Critical Care® sessions with clients, we often see unused indexes (reads=0) with high writes. Sometimes these unused indexes have very high writes. If an index is never being used to help with performance but SQL Server is having to main …

Modern Data Warehouse Design Pattern – Part II

Publié le 2 octobre 2018 sur sqlservercentral.com
 

Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.

Who’s Using the DAC?

Publié le 2 octobre 2018 sur sqlservercentral.com
 

Learn how you can determine which connection is using the Dedicated Administrator Connection.

Free 1 Hour Consulting – PASS Pre-Con 2018 – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs

Publié le 2 octobre 2018 sur journey to sqlauthority
 

Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is a ful …

Adaptive Query Processing in SQL Server 2017

Publié le 1 octobre 2018 sur simple-talk.com
 

SQL Server 2017 now offers adaptive query processing, a new set of features aimed at improving query performance. Adaptive query processing addresses issues related to cardinality estimates in execution plans, leading to better memory allocation, join …

The New Lightweight Query Plan Profile Hint

Publié le 1 octobre 2018 sur brentozar.com
 

Recent Updates To SQL Server 2016 and 2017 introduced a new USE HINT that lets you direct an actual execution plan to a new Extended Event, called query_plan_profile. The hint by itself doesn’t do anything, and the XE by itself doesn …

Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption

Publié le 1 octobre 2018 sur sqlservercentral.com
 

In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony D …

Compress and Decompress in SQL Server 2016

Publié le 1 octobre 2018 sur sqlservercentral.com
 

Explore using Compress/Decompress with varying types of data and examine size/storage usage

Exhuming the GDPR Bodies

Publié le 1 octobre 2018 sur sqlservercentral.com
 

Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that d …

SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]

Publié le 1 octobre 2018 sur journey to sqlauthority
 

While playing with my virtual machine, I encountered an interesting error. In this blog we would learn how to fix error cannot connect to WMI provider [0x80070422] while launching SQL Server Configuration Manager. As I have been writing in my earlier b …

How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193

Publié le 30 septembre 2018 sur journey to sqlauthority
 

Question: How to STOP the Usage of SELECT * For Views? Answer: Last week was a very interesting week, during the recent Comprehensive Database Performance Health Check, we identified a query which was running very slow for our customer. After …

SQL SERVER 2019 – Oracle JRE 7 Update 51 (64 Bit) or Higher is Required

Publié le 29 septembre 2018 sur journey to sqlauthority
 

This is my second blog about SQL Server 2019. My previous blog was about the release announcement of SQL Server 2019 CTP version. SQL Authority News – Microsoft Released SQL Server 2019 Preview. In this blog post, we will discuss about Oracl …

When You Need to Tune A View, Don’t Just Get Its Plan

Publié le 28 septembre 2018 sur brentozar.com
 

Say your database has a view, and everybody’s queries use it. Let’s take the Stack Overflow database and create this view:CREATE OR ALTER VIEW dbo.vwQuestionsAndAnswers AS SELECT q.Title, q.Id AS QuestionId, a.Id AS AnswerId, a.Body AS Answ …

What’s New in the First Public CTP of SQL Server 2019

Publié le 28 septembre 2018 sur sqlservercentral.com
 

In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.


Pages :