Bert Wagner

CHOOSE() in SQL Server

Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...

2019-06-04

269 reads

IN vs UNION ALL

Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...

2019-05-13 (first published: )

1,173 reads

Correlated Subqueries vs Derived Tables

Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on....

2019-05-07 (first published: )

1,275 reads

Temporary Staging Tables

Watch this week’s episode on YouTube. SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb....

2019-05-07

134 reads

Window Functions vs GROUP BYs

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 those features (eg. vendor...

2019-04-25 (first published: )

1,139 reads

Blogs

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

Storing JSON data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Storing JSON data

Memories of DR testing

By MVDBA

Comments posted to this topic are about the item Memories of DR testing

Phishing Defenses

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Phishing Defenses

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers