Author: Paul Randal

The Curious Case of… unstoppable DBCC CHECKDB

(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 with a client, doing some testing, or were asked in a random question from the community.) Last week I […]

The post The Curious Case of… unstoppable DBCC CHECKDB appeared first on Paul S. Randal.

The Curious Case of… faster disks causing more WRITELOG waits

(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 with a client, doing some testing, or were asked in a random question from the community.) I was contacted […]

The post The Curious Case of… faster disks causing more WRITELOG waits appeared first on Paul S. Randal.

PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux

Last week I blogged about Using the Wait Statistics Report in Azure Data Studio, using a Linux VM in Azure as an example host. As that was my first time running wait stats analysis on a Linux host, I found that the PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux will show up as the top wait on SQL […]

The post PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux appeared first on Paul S. Randal.

The Curious Case of… copying FILESTREAM files between tables

(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 with a client, doing some testing, or were asked in a random question from the community.) I […]

The post The Curious Case of… copying FILESTREAM files between tables appeared first on Paul S. Randal.

Using the Wait Statistics Report in Azure Data Studio

Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Server Reports extension. In this quick post I’ll show you how to install […]

The post Using the Wait Statistics Report in Azure Data Studio appeared first on Paul S. Randal.

2018: the year in books – a new record!

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017) and people have been enjoying it, so here I present the 2018 end-of-year post. I set a moderate goal of 50 books this year but obliterated that and […]

The post 2018: the year in books – a new record! appeared first on Paul S. Randal.

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569