In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers