Jason Brimhall


Blog Post

May I help you?

With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games.  Those were the greatest winter...

2010-02-18

823 reads

Blog Post

DBA.Sleep(8hrs)

I have been pondering recently what helps me to sleep at night.  Or, conversely, what prevents me from sleeping at...

2010-02-17

1,320 reads

Blog Post

In Vs. Inner Join

This is tightly related to another of my forays into tuning some slowly/poorly performing processes.  This process came across my...

2010-02-16

872 reads

Blog Post

PayPeriod II

I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...

2010-02-14

794 reads

Blog Post

Relationships

This month Rob Farley is hosting TSQL-Tuesday #3.  The topic is Relationships and he has left it wide open for...

2010-02-09

881 reads

Blog Post

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:

T-SQL Tuesday Participation Over the Years December 19, 2018

T-SQL Tuesday #104: Just Can't Cut That Cord...

2010-02-02

9 reads

Blogs

Upgrading SQL Server Containers on the Laptop

By

I don’t have SQL Server installed on my laptop. In an effort to keep...

How to Find Expensive Queries in Amazon Redshift

By

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

By

If you've been here before, you know this blog is usually about SQL Server,...

Read the latest Blogs

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

By millardus

Hi all Can I get some perspective from the community please on performing in-place...

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

T-SQL Trigonometric Functions in SQL Server

By Imran2629

Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers