4 Reasons To Avoid VARCHAR(8000)

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...

2019-04-05 (first published: 2019-03-19)

1,491 reads

Dipping into the Cookie Jar

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill.  T-SQL Tuesday is a way for the SQL...

2019-03-29 (first published: 2019-03-12)

272 reads

Joining on NULLs

• by Bert Wagner

• Bert Wagner

It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...

2019-03-26

9 reads

Time Zones and Daylight Saving Time

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTubeAT TIME ZONE is great because it makes it easy to perform daylight saving time and...

2019-03-19 (first published: 2019-03-05)

2,419 reads

Gaps and Islands Across Date Ranges

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...

2019-03-12

994 reads

COUNT, DISTINCT, and NULLs

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...

2019-03-05 (first published: 2019-02-19)

2,681 reads

Why make?

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard.  T-SQL Tuesday is a way...

2019-03-01 (first published: 2019-02-12)

3,216 reads

Searching Complex JSON Data

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...

2019-02-26

318 reads

Parsing HTML in SQL Server

• by Bert Wagner

• Bert Wagner

Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...

2019-02-12

1,023 reads

Optimizing for Ad Hoc Workloads

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...

2019-02-07 (first published: 2019-01-22)

2,049 reads