Moving on from Volunteer Projects
The post Moving on from Volunteer Projects appeared first on SQLServerCentral.
Combining many crossing intervals
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
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”?
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
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.
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
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
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
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
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
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
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
(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
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
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 …