2011-11-15
2,157 reads
2011-11-15
2,157 reads
Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.
2011-11-15
3,225 reads
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
2010-01-15 (first published: 2008-09-01)
29,079 reads
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
By Rohit Garg
📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors...
Comments posted to this topic are about the item The Technical Debt Anchor
Comments posted to this topic are about the item Getting the Updated Column List
Here's the complete error: An error occurred during local report processing. The definition of...
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers