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,916 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,795 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,166 reads
2015-12-14
1,478 reads
2015-12-07
1,382 reads
2015-11-30
1,326 reads
2015-11-19
1,634 reads
2015-11-13
1,374 reads
2015-11-09
1,631 reads
2015-11-03
1,806 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers