2024-04-05
717 reads
2024-04-05
717 reads
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,696 reads
2023-04-19
638 reads
2020-01-23
907 reads
2019-10-28
540 reads
2019-08-26
1,155 reads
2019-06-17
821 reads
2019-02-11
866 reads
2019-01-04
983 reads
2018-10-12
946 reads
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers