Sites anglophones


Why Execution Plan Operator Read More Rows Than Available? – Interview Question of the Week #255

Publié le 15 décembre 2019 sur journey to sqlauthority
 

Question: Why Execution Plan Operator Read More Rows Than Available?Answer: Statistics.The short answer is it is because of statistics, however, let us learn about the detailed answer in this blog post. I received this question during my recent consult …

SQL SERVER – Query Without Join Showing Query Plan With Join

Publié le 14 décembre 2019 sur journey to sqlauthority
 

Recently One of my clients asked me questions about why their query plan is displaying the join when the query has no join syntax and it is just on a single table. I often discuss this in my Comprehensive Database Performance Health Check. This questio …

SQL SERVER – Persisting Sample Percentage for Statistics – PERSIST_SAMPLE_PERCENT

Publié le 13 décembre 2019 sur journey to sqlauthority
 

What I like the most about Microsoft is that they frequently release a new version of SQL Server. The most common problem I have after upgrading to the latest SQL Server is performance regression after an upgrade and that is what brings lots of custome …

Azure Text Analytics and Power BI

Publié le 13 décembre 2019 sur sqlservercentral.com
 

The post Azure Text Analytics and Power BI appeared first on SQLServerCentral.

SQL SERVER – List All the Nullable Columns in Database

Publié le 12 décembre 2019 sur journey to sqlauthority
 

Another day and another win against a difficult SQL Server Problem while I worked with my clients on  Comprehensive Database Performance Health Check. The best part of my job is that I get to work with different performance problems every time wit …

Querying Master Database DMVs in Azure SQL Database

Publié le 12 décembre 2019 sur sqlservercentral.com
 

When you move to an Azure SQL Database, the idea is that you are working within a database, not an instance. In fact, for the most part, you don’t access the master database at all. There is a logical SQL Server, which provides logins and connections, …

Are You Underpaid? Let’s Find Out: The Data Professional Salary Survey is Open.

Publié le 11 décembre 2019 sur brentozar.com
 

It’s time for our annual salary survey to find out what data professionals make. You fill out the data, we open source the whole thing, and you can analyze the data to spot trends and do a better job of negotiating your own salary:   I make …

SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient

Publié le 11 décembre 2019 sur journey to sqlauthority
 

One thing I keep on telling my clients that it is not that always recommended to use the latest feature without proper testing. I was recently hired by clients to help them with tuning a query for SQL Server 2019 Comprehensive Database Performance Heal …

Analyze and Improve SQL Server Backup Schedule

Publié le 11 décembre 2019 sur sqlservercentral.com
 

The post Analyze and Improve SQL Server Backup Schedule appeared first on SQLServerCentral.

SQL SERVER – List Number Queries Waiting for Memory Grant Pending

Publié le 10 décembre 2019 sur journey to sqlauthority
 

I have been recently writing about Memory Grant Feedback a lot and I have received a lot of questions about it. I have been answering each of them personally but some questions are so good that I feel like answering them on the blog will help more peop …

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

Publié le 10 décembre 2019 sur sqlservercentral.com
 

The post Deploying Data and Schema Together with SQL Compare or SQL Change Automation appeared first on SQLServerCentral.

SQL Server Name Convention and T-SQL Programming Style

Publié le 10 décembre 2019 sur sqlservercentral.com
 

There are only two hard things in Computer Science: cache invalidation and naming things — Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your nee …

Upsizing the SQL ConstantCare® Database Servers

Publié le 9 décembre 2019 sur brentozar.com
 

If you’re looking for SQL Server news, just skip this post. I’m going to talk about general business & capacity planning type stuff here today. Our SQL ConstantCare® customers install an app that polls diagnostic data from their SQL …

SQL SERVER – Row Mode and Memory Grant Feedback

Publié le 9 décembre 2019 sur journey to sqlauthority
 

Earlier this year, I had a great time writing on the Memory Grant Feedback. I have received a lot of questions about this feature and I have tried my best to answer each of them. One of the questions, which really caught my attention did this feature w …

Increase Query Speed with Covering Indexes

Publié le 9 décembre 2019 sur sqlservercentral.com
 

Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them. What is a coverin …


Pages :