Set-Based vs Row-Based Database Code
December 1, 2023
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
Dallas DBAs Blogs
Blog posts by Kevin Hill and other Dallas DBAs team members.
Popular Blogs
SQL Server backups to Azure Blob storage
January 16, 2018
Why is my SQL Log File Huge?
March 8, 2017
Your DR Plan isn’t a Plan
August 8, 2018
SSIS Memory errors
August 30, 2017
Join vs. IN Not IN
August 9, 2016
All Categories
SQL 101 – Understanding Transaction logs
January 9, 2008
SQL 101 – Understanding Transaction logs I posted this in the microsoft.public.sqlserver.server newsgroup (response to
Fun with the overnight crew…
December 10, 2007
Dateline: Sunday morning, 2:30am (my week on call)… Ring!!!!! Kevin3NF: {snort} thisiskevin Caller: Hey man…sorry
Why we maintain databases
November 20, 2007
Why we maintain databases… I was blissfully unaware of this issue until I came in
Do What?
October 25, 2007
Do what? So….I’ve got this job that backs up the T-log every 15 minutes (SQL
Re-initializing Log Shipping Sucks
August 20, 2007
2005 Log Shipping ok…I’m behind the times and just started working with SQL Server Log
MSDB Cleanup
February 6, 2007
Enterprise Manager hang My customer’s SQL 2000 .818 box has started timing out when he
Stay Informed.
Signup and receive news and updates from Dallas DBAs.
