Sites anglophones


[Video] Office Hours: Open Q&A About SQL Server

Publié le 3 septembre 2020 sur brentozar.com
 

Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific …

Recover Crashed Query in SSMS – SQL in Sixty Seconds #116

Publié le 3 septembre 2020 sur journey to sqlauthority
 

Has it ever happened to you when you are working on a large SQL Server query and suddenly your SQL Server Management Studio (SSMS) crashes? Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we …

Installing PostgreSQL 11 on Windows with Step-by-step Instructions

Publié le 3 septembre 2020 sur sqlservercentral.com
 

PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation proces …

How do You Identify Object Dependencies in SQL Server

Publié le 3 septembre 2020 sur sqlservercentral.com
 

The post How do You Identify Object Dependencies in SQL Server appeared first on SQLServerCentral.

What’s The First Thing You Tell Your Underling?

Publié le 2 septembre 2020 sur brentozar.com
 

You were just given permission to hire an underling, and today’s their first day reporting to you. What’s the first thing you warn them about? I asked on Twitter, and the replies were great: Don’t be afraid to fail. Fail as much as you want …

Activity Monitor and Running Query – SQL in Sixty Seconds #115

Publié le 2 septembre 2020 sur journey to sqlauthority
 

Activity Monitor can come handy when you are in trouble as well. In this video, we will see how we can take the help of Activity Monitor to track Actively Running Query. If you are using SQL Server 2019, the feature described in this blog is by default …

Using Filters to Fine-tune Redgate Database Deployments

Publié le 2 septembre 2020 sur sqlservercentral.com
 

The post Using Filters to Fine-tune Redgate Database Deployments appeared first on SQLServerCentral.

Hands-On with Columnstore Indexes: Part 4 Query Patterns

Publié le 1 septembre 2020 sur simple-talk.com
 

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options Hands-On with Columnstore Ind …

SQLBits Attendees: Here Are Your Prerequisites for Mastering Index Tuning.

Publié le 1 septembre 2020 sur brentozar.com
 

Howdy folks. It’s time for SQLBits! This year, I’m teaching a one-day Mastering Index Tuning workshop from 9AM-5PM London time, and you can join in online. Pricing is £300 for the one-day workshop, or £800 for a full conference …

Email an Execution Plan – SQL in Sixty Seconds #114

Publié le 1 septembre 2020 sur journey to sqlauthority
 

Most part of my day is spent doing Comprehensive Database Performance Health Check with different organizations. During the consultation, we focus on SQL Server Configuration, Database Deployment, Index Optimizations as well as Query Tuning. Additional …

Getting Started with Delta Lake Using Azure Data Factory

Publié le 1 septembre 2020 sur sqlservercentral.com
 

The post Getting Started with Delta Lake Using Azure Data Factory appeared first on SQLServerCentral.

Using Recommendations for MAXDOP and Max Memory During Installation

Publié le 1 septembre 2020 sur sqlservercentral.com
 

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article loo …

SQL ConstantCare® Population Report: Summer 2020

Publié le 31 août 2020 sur brentozar.com
 

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2020 version of our SQL Const …

Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113

Publié le 31 août 2020 sur journey to sqlauthority
 

During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Today we are going to discuss differences and similarity between them.Lots of people think that Estimated Executed Plan are n …

What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291

Publié le 30 août 2020 sur journey to sqlauthority
 

Question: What Happens If the Clustered Index is Disabled?Answer: If you disable the clustered index, you can’t retrieve data from the table. Technically the entire table goes offline, till you rebuild your clustered index.A clustered index is ac …


Pages :