Trust, or Verify – How FKs Can (or Cannot) Help Performance
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,870 reads
Hugo Kornelis
Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)
In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.
2018-08-08 (first published: 2016-11-23)
3,759 reads
Stairway to Columnstore Indexes Level 9: Batch Mode Execution
In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.
2018-07-04 (first published: 2016-08-31)
4,133 reads
2015-12-14
1,476 reads
2015-12-07
1,378 reads
2015-11-30
1,319 reads
2015-11-19
1,623 reads
2015-11-13
1,370 reads
2015-11-09
1,625 reads
2015-11-03
1,801 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...