Browse the archive

T-SQL

TSQL Tuesday #104: dbo.Check_FileSize

July 9, 20187 min read

It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner's call to blog about code I would hate to live without

Databases

TSQL Tuesday #99: Tabs vs Spaces

February 13, 20188 min read

The great tabs vs spaces debate is often framed as a matter of opinion or coding style. “As long as you’re consistent, it doesn’t matter.” Keep in mind that unlike your choice in footwear, coding style can’t be personal. I’m going to draw a line in the sand …

Databases

TSQL Tuesday #99: SQL Tourism

February 13, 20189 min read

When I started travelling to speak at SQL Server events, I committed that I would make the most of it. To me, that means a lot more than just attending the event where I’m speaking. Sure, I want to learn and network at the event, but it means more than that, …

Databases

Parsing file names from paths using T-SQL

January 17, 20186 min read

As a DBA, there seems to be a constant trickle of automation where I need to parse a file name out of a full path. So let's parse this stuff in T-SQL, even though other languages might be better for this.

Databases

Finding active transactions

January 2, 20185 min read

Find active SQL Server transactions and avoid leaving uncommitted work that can block other users.

Databases

Finding the Leader Blocker

October 26, 20178 min read

Learn how to identify the head blocker in SQL Server and trace a blocking chain to its source.

Databases

Multi-Statement TVFs in Dynamics CRM

August 22, 20179 min read

In this post, I walk through identifying and fixing a serious performance issue with a multi-statement TVF in Dynamics CRM.

Databases

What’s wrong with DELETE EXISTS?

June 30, 20174 min read

A closer look at DELETE statements that use EXISTS, and the problems this pattern can hide.

Databases

TSQL Tuesday #85: Backup + Recovery + ☁️

December 13, 20167 min read

It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's …

Databases

T-SQL Tuesday #83: Roundup

October 16, 20163 min read

For this month’s T-SQL Tuesday, I asked people to blog about the same old problems we’ve been dealing with for years. There were some great posts, including a batch of first-time contributors. You’ll notice some overlapping themes as you read through these …