Sites anglophones


Online class recordings available to purchase

Publié le 13 mars 2020 sur sqlskills.com - paul randall
 

By popular demand we’ve made the recordings of our live, online classes available to purchase – now you have a way to learn from us while you’re stuck working from home! These classes were all delivered live during 2019 and recorded u …

“Working” From Home? Watch A Bunch of Free SQL Server Videos on YouTube.

Publié le 13 mars 2020 sur brentozar.com
 

You’re new at this working from home thing, and you’re trying to put Game of Thrones up on a second monitor while you work? Listen, that’s not gonna play out well. You’re gonna get distracted and you’re not gonna get any w …

SQL SERVER – Scheduler_ID with Large Number in dm_os_schedulers

Publié le 13 mars 2020 sur journey to sqlauthority
 

The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers while working with the Comprehensive Database Performance Health Check. During the consultation, I had provided the s …

Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY

Publié le 13 mars 2020 sur sqlservercentral.com
 

The post Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY appeared first on SQLServerCentral.

April/May classes in Chicago moved to October

Publié le 12 mars 2020 sur sqlskills.com - paul randall
 

Given the current COVID-19/coronavirus pandemic and the many travel restrictions in place, we have moved all our Spring classes to October, and all registered students have been contacted individually. If you were concerned about signing up for the cla …

How to Track Performance of Queries That Use RECOMPILE Hints

Publié le 12 mars 2020 sur brentozar.com
 

Say we have a stored procedure that has two queries in it – the second query uses a recompile hint, and you might recognize it from my parameter sniffing session:CREATE OR ALTER PROC dbo.usp_SearchUsers @Reputation INT AS BEGIN /* Query 1, always …

SQL SERVER – Query to List Active and Inactive VLF

Publié le 12 mars 2020 sur journey to sqlauthority
 

Recently, I had a very interesting experience with one of my clients where we observed a large number of VLF files impacting negatively to their performance. We used the in-famous DBCC SHRINKFILE to reduce the VLFs. During the  Comprehensive Datab …

Using the RANKX function in Power BI

Publié le 12 mars 2020 sur sqlservercentral.com
 

Introduction In this article, I’ll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It …

The Curious Case of… the 8060-byte row size limit

Publié le 11 mars 2020 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 …

Storage 101: Understanding the NAND Flash Solid State Drive

Publié le 11 mars 2020 sur simple-talk.com
 

Solid-state drive (SSDs) have made significant inroads into enterprise data centers in recent years, supporting workloads once the exclusive domain of hard-disk drive (HDDs). SSDs are faster, smaller, use less energy, and include no moving parts. They …

How COVID-19 Affects Conferences

Publié le 11 mars 2020 sur brentozar.com
 

SQLBits just postponed their event, and I’m stepping out of SQL Saturday Iceland as well. I’ve had the unusual position of being a conference attendee, speaker, and sponsor, all at different times of my life, so I wanted to do a quick brain …

SQL SERVER – Reducing TempDB Recompilation with Fixed Plan

Publié le 11 mars 2020 sur journey to sqlauthority
 

Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.Real-World ScenarioOne of the large …

Things to Consider When SQL Server Asks for an Index

Publié le 10 mars 2020 sur brentozar.com
 

One of the things I love about SQL Server is that during query plan compilation, it takes a moment to consider whether an index would help the query you’re running. Regular blog readers will know that I make a lot of jokes about the quality of th …

T-SQL Tuesday #124: Using Query Store (and why you might not be…yet)

Publié le 10 mars 2020 sur SQLSkills.com - Erin Stellato
 

T-SQL Tuesday This month’s T-SQL Tuesday topic is courtesy of Tracy Boggiano and it’s related to using Query Store!  Tracy asked people to write about their experience adopting Query Store (or not, if you haven’t tried it ye …

SQL SERVER Tools I Use and Recommend (Updated: March 2020)

Publié le 10 mars 2020 sur journey to sqlauthority
 

One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for March 2020 of all the tools which I …


Pages :