Sites anglophones


Moving on from Volunteer Projects

Publié le 16 mars 2020 sur sqlservercentral.com
 

The post Moving on from Volunteer Projects appeared first on SQLServerCentral.

Combining many crossing intervals

Publié le 16 mars 2020 sur sqlservercentral.com
 

Problem Combining overlapping or continuous intervals could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of the geometry data type and an unknown function (if not, maybe less used function) s …

How to Decode @@OPTIONS Value? – Interview Question of the Week #268

Publié le 15 mars 2020 sur journey to sqlauthority
 

There are situations where set options can change the query behavior of a session. The session-level options can be found using the @@options variable in SQL Server. In this blog, I am sharing a useful script which can be used to decode the value of th …

SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?

Publié le 14 mars 2020 sur journey to sqlauthority
 

One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather? It might be freezing over there and that’s why SQL is saying:   “I/O is frozen on …

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 …


Pages :