Sites anglophones


SQLskills SQL101: Upgrading to a Different Edition of SQL Server

Publié le 8 août 2019 sur sqlskills.com - glen berry
 

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that …

What columns are in that index?

Publié le 8 août 2019 sur SQLSkills.com - Erin Stellato
 

I’ve been helping several customers with tuning lately, which typically means I’m also looking at indexes and asking questions. A pattern I’ve noticed is columns from the clustering key being added to the key definition for the nonclu …

SQL SERVER – DELETE Qualified Rows From Multiple Tables – Part 2

Publié le 8 août 2019 sur journey to sqlauthority
 

Earlier this week, I had announced a contest to get Recorded PASS of my extremely popular training SQL Server Performance Tuning Practical Workshop – Recorded Classes. As the price of this class high, I wanted to keep my contest difficult as …

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

Publié le 8 août 2019 sur sqlservercentral.com
 

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to on …

Problems Caused by Use of the SQL_VARIANT Datatype

Publié le 8 août 2019 sur sqlservercentral.com
 

The post Problems Caused by Use of the SQL_VARIANT Datatype appeared first on SQLServerCentral.

SQL Server Diagnostic Information Queries for August 2019

Publié le 7 août 2019 sur sqlskills.com - glen berry
 

This month, I have added a new set of queries for SQL Managed Instance. If you are using SQL Managed instance, please try it out and let me know what you think.I have a T-SQL script that you can use to check whether your instance of SQL Server has been …

Yes and No Questions Are Not So Simple

Publié le 7 août 2019 sur simple-talk.com
 

Yes! We Have No Bananas Song by Frank Silver and Irving Cohn There’s a fruit store on our street It’s run by a Greek. And he keeps good things to eat But you should hear him speak! When you ask him anything, he never answers “no …

SQL SERVER – Best Value for Max Worker Count

Publié le 7 août 2019 sur journey to sqlauthority
 

I have been working as a SQL Server Performance Tuning Consultant for over 10 years. During the last 10 years, I have worked with over 100s of clients helping them with Comprehensive Database Performance Health Check. My experience says that most of th …

Relational Databases vs Graph Databases

Publié le 7 août 2019 sur sqlservercentral.com
 

The post Relational Databases vs Graph Databases appeared first on SQLServerCentral.

The Curious Case of… what is the wait resource (0:0:0)?

Publié le 6 août 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

DBA Training Plan 8: What’s Inside Your Own Databases

Publié le 6 août 2019 sur brentozar.com
 

In the last episode of the DBA Training Plan, we talked about what’s inside the MDF file: a series of pages that store a database’s tables. Now, it’s time to check out the contents of YOUR database to understand what’s using the …

SQL SERVER – Retrieving N Rows After Ordering Query With OFFSET

Publié le 6 août 2019 sur journey to sqlauthority
 

As many of you know my SQL Server Performance Tuning Practical Workshop was sold out for June and July. That was the primary reasons, I was not able to write blog posts based on questions received in an email. Today, we will see the solution to very in …

Data privacy. Don’t look forward. Look back.

Publié le 6 août 2019 sur sqlservercentral.com
 

The post Data privacy. Don’t look forward. Look back. appeared first on SQLServerCentral.

“But NOLOCK Is Okay When The Data Isn’t Changing, Right?”

Publié le 5 août 2019 sur brentozar.com
 

I’ve already covered how NOLOCK gives you random results when you’re querying data that’s changing, and that’s a really powerful demo to show folks who think NOLOCK is safe to use in production. However, I’ve gotten a ques …

SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache

Publié le 5 août 2019 sur journey to sqlauthority
 

Earlier this weekend, I had an urgent product to help. One of my clients reached out to me as their application stopped running in the middle night on Saturday. The issue was indeed a strange one as they have very little traffic on weekends and particu …


Pages :