Bert Wagner

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,086 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...

5 (1)

2019-04-25 (first published: )

1,094 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

CPU?Memory and IO bottleneck check

By 892717952

Which indices will show  cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers