Skip to content

SQLBlog.org

SQLBlog.org

Heaps, LOBs, and aggregates : A bad combination

Aaron Bertrand May 26th, 2020 SQL Server

Dig into an intermittent stack dump involving an aggregate query against a heap with a LOB column.

SQL Server Cumulative Updates Delayed

Aaron Bertrand May 13th, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

Cumulative Updates for SQL Server 2019, SQL Server 2017, and SQL Server 2016 SP2 have been pushed back a month or more due to our current health crisis.

Bad Habits to Kick : Relying on undocumented behavior

Aaron Bertrand May 12th, 2020 Bad Habits & Best Practices / SQL Server

Discover some undocumented or unsupported behavior you might not even realize you're relying on.

Bad Habits and Best Practices

Aaron Bertrand May 12th, 2020 Bad Habits & Best Practices / SQL Server

An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.

Happy Cinco de Mayo and Happy Taco Tuesday!

Aaron Bertrand May 5th, 2020 General / SQL Server

See a quick T-SQL script for determining how often Cinco de Mayo falls on Taco Tuesday.

Index and Partition Space Usage – Part 2

Aaron Bertrand May 4th, 2020 SQL Server

I continue a series where I dig into how data is distributed across indexes, files, and filegroups.

"0 to 60" : Switching to indirect checkpoints

Aaron Bertrand May 1st, 2020 SQL Server

I talk about a recent change where I started turning on indirect checkpoints across all user databases.

Removing the default trace – Part 3

Aaron Bertrand April 22nd, 2020 Extended Events / SQL Server

I finish up my series on replacing the default trace with views to simplify consumption and a caveat about reports in SSMS.

SQL Server 2017 Cumulative Update #20

Aaron Bertrand April 8th, 2020 SQL Server 2017

SQL Server 2017 Cumulative Update #20 is available, with 40 enhancements. The build number is 14.0.3294.2.

File and Filegroup Space Usage – Part 1

Aaron Bertrand April 7th, 2020 SQL Server

See the stored procedure I wrote to help me put all file, filegroup, and index information in one place.

Removing the default trace – Part 2

Aaron Bertrand April 6th, 2020 Extended Events / SQL Server

I continue my series on replacing the default trace with a more efficient and more complete Extended Events session.

SQL Server 2019 Cumulative Update #4

Aaron Bertrand March 31st, 2020 SQL Server 2019

SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The build number is 15.0.4033.1.

Blogging is for more than just traffic

Aaron Bertrand March 27th, 2020 Career / Community

See how blogging can benefit both the author and the reader in this short opinion piece.

A minor office reorg – part 3

Aaron Bertrand March 22nd, 2020 General

Phase 3 of my home office – doors! – couldn't have happened at a better time.

Please help with STRING_SPLIT improvements

Aaron Bertrand March 20th, 2020 SQL Server vNext

I want to push for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help!

Illogical errors can be a factor of the plan

Aaron Bertrand March 19th, 2020 SQL Server

See a quick example where plan shape can cause errors that really shouldn't happen.

Changing a function's interface but staying backward compatible

Aaron Bertrand March 18th, 2020 SQL Server

In this tip, see ways you can change how a function is called without having to modify all calling code at the same time.

Attaching / restoring databases inside a container

Aaron Bertrand March 15th, 2020 SQL Server

Need to get data, log, or bak files into your container's file system? See how, with docker cp.

SQL Server 2019 Cumulative Update #3

Aaron Bertrand March 13th, 2020 SQL Server 2019

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.

Additional Tips for Working From Home

Aaron Bertrand March 12th, 2020 General

With the increasing number of office closures, I share some tips about working from home.

Measure Delayed Durability impact in SQL Server 2016 and later

Aaron Bertrand March 4th, 2020 SQL Server 2016 / SQL Server 2017 / SQL Server 2019

In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.

  • « Previous Page
  • Next Page »

© 2006-2021 Aaron Bertrand. All Rights Reserved. Disclaimer, CC BY-SA 3.0 US.