Sites anglophones


SQL SERVER – Live Query Statistics – SQL in Sixty Seconds #104

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

It is very easy to know what is the queries past and future with the help of the execution plan as well as Dynamic Management Views. However, the biggest challenge is to know the details about the queries current execution status. In this SQL in Sixty …

Redgate Streamed Returns

Publié le 19 août 2020 sur sqlservercentral.com
 

The post Redgate Streamed Returns appeared first on SQLServerCentral.

Heaps in SQL Server: Part 3 Nonclustered Indexes

Publié le 18 août 2020 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps in SQL Server: Part 3 Nonclustered Indexes The previous article Heaps in SQL Server: Part 2 Optimizing Reads described how performance could be …

sp_BlitzIndex Pro Tips for Consultants & Contractors

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

sp_BlitzIndex analyzes the design & health of your clustered & nonclustered rowstore indexes and gives you suggestions on how to get higher performance without changing your queries. If you run it with no parameters, you get advice on the index …

SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103

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

During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differenc …

Maximize View of SQL Server Query Plans with Full Screen Option

Publié le 18 août 2020 sur sqlservercentral.com
 

The post Maximize View of SQL Server Query Plans with Full Screen Option appeared first on SQLServerCentral.

Recover database encrypted modules code with dbatools

Publié le 18 août 2020 sur sqlservercentral.com
 

SQL Server offers an option to encrypt the code of your modules when using the ‘WITH ENCRYPTION’ syntax. This allows to hide/obfuscate the modules’ code and thus keep away from prying eyes. It’s often used to protect business rules since it allows you …

Explaining SQL Server Statistics with Playing Cards

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

When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio: Here’s the demo script I use in the video. T …

Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102

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

What I love most about my job Comprehensive Database Performance Health Check, is that I get to work with different people and answer questions. Today we will see a very interesting question – Are Not Equal (<> or !=! to Operators Equal to …

Create Azure Data Factory inventory using Databricks

Publié le 17 août 2020 sur sqlservercentral.com
 

The post Create Azure Data Factory inventory using Databricks appeared first on SQLServerCentral.

The Two Ways Containers Will Revolutionize Database DevOps

Publié le 17 août 2020 sur simple-talk.com
 

Table of Contents Revolution 1 – Database Provisioning as a Service Why didn’t this happen earlier with SAN automation and virtualization? Why do containers change this? They aren’t inherently stateful Steve Jones shows what the futur …

How to override Date Filters in Power BI

Publié le 17 août 2020 sur sqlservercentral.com
 

Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select …

Do MAX Function Scan Table? – Interview Question of the Week #289

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

Question: Do MAX Function Scan Table to retrieve the data?Answer: Yes, if there are no indexes to help retrieve data.I personally hate answers which are ambiguous and I also do not like to say it depends as well. Let me say in simple possible words wha …

SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)

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

The other day, I received an email from my client of Comprehensive Database Performance Health Check. The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)The …

Negative Identity Column – SQL in Sixty Seconds #101

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

I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.Real-World StoryRecently I had the opportunity to work on a project where my client had a negative identity column. T …


Pages :