Temporary Staging Tables
Watch this week's video 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. On...
2019-05-07
5 reads
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: 2019-04-30)
1,314 reads
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
2 reads
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
10 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: 2019-04-23)
1,716 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
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...
2019-04-23
7 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
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...
2019-04-23
10 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: 2019-04-16)
1,239 reads
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
5 reads
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
5 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers