Sites anglophones


SQL SERVER – Identifying Query Using TempDB

Publié le 17 septembre 2018 sur journey to sqlauthority
 

During the recent Comprehensive Database Performance Health Check we observed that the size of the TempDB is very big for our customer. The first question which they asked was if there is any way they can identify query using TempDB. We ran the fo …

Where is the Default Settings for Backup Compression? – Interview Question of the Week #191

Publié le 16 septembre 2018 sur journey to sqlauthority
 

Question: Where is the Default Settings for Backup Compression? Answer: I think before I continue more on this blog post, I must show you an image which has created this question. Please look at the following database settings screen. You can go t …

[Video] Office Hours 2019/09/12 (With Transcriptions)

Publié le 15 septembre 2018 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on …

SQL SERVER – Monitor Estimated Completion Times for Backup, Restore and DBCC Commands

Publié le 15 septembre 2018 sur journey to sqlauthority
 

Earlier this week, we were fortunate to receive an amazing script to overview HADR / AlwaysOn Local Replicate server from SQL Server Expert Dominic Wirth. You can read the amazing script here: Scripts to Overview HADR / AlwaysOn Local Replica Serv …

Microsoft Docs and Localization Community Platform

Publié le 14 septembre 2018 sur sqlblog.com
 

Microsoft Docs is the new platform for sharing high quality technical documentation about Microsoft technologies and related products.The documentation is hosted on GitHub and it is open to changes.Now, technical communities around the world have the o …

Should Index Changes Require Change Control?

Publié le 14 septembre 2018 sur brentozar.com
 

We got a phenomenal series of questions from a client, and I wanted to encapsulate the answers into a blog post to help more folks out: Should all index changes require testing in a staging environment, no matter how big or small? What would be a reaso …


Pages :