Set-Based vs Row-Based Database Code
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications
SQL Server Database Consulting
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications
Blog posts by Kevin Hill and other Dallas DBAs team members.
T-SQL Tuesday is a blog party started by Adam Machanic (b/t) over five years ago.
Thanks to Andy Warren (b|t) for this idea…. I am starting a collection of “How
In my Top 10 SQL Server Functions post awhile back, I listed DBCC OPENTRAN as
Quick post in response to a number of Twitter and Forum questions I’ve seen lately.
I re-posted SQL 101 Blocking vs. Deadlocking – in English for the Non-DBA the other day for
Quickie today…. Someone please tell me why this is considered insecure: A stored procedure that,