Bert Wagner

Blog Post

Window Functions vs GROUP BYs

Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...

2019-04-16

9 reads

Blog Post

Window Functions vs GROUP BYs

Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...

2019-04-16

8 reads

Blog Post

Joining on NULLs

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

30 reads

Blog Post

Joining on NULLs

Watch this week's video on YouTube
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...

2019-03-26

6 reads

Blogs

AI: Blog a Day – Day 7: Vector and Vector Databases

By

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...

AI: Blog a Day – Day 6: Embeddings – How AI Understands

By

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

The Book of Redgate: Mistakes

By

This is kind of a funny page to look at. The next page has...

Read the latest Blogs

Forums

Why End-User Testing Is Even More Important with AI

By dbakevlar

Comments posted to this topic are about the item Why End-User Testing Is Even...

Dynamic Unpivot

By pietlinden

I have a table I didn't design that has tons of repeating groups in...

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers