2024-04-05
714 reads
Thomas Franz
Get the Most Current Row From a Detail Table
This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.
2023-07-10
3,638 reads
2023-04-19
633 reads
2020-01-23
905 reads
2019-10-28
538 reads
2019-08-26
1,155 reads
2019-06-17
819 reads
2019-02-11
865 reads
2019-01-04
983 reads
2018-10-12
945 reads
Blogs
Communicate to the Individual
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know
By Rohit Garg
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...
Forums
SQL Server 2008 to SQL Server 2022
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers