Using the default SQL Server READ COMMITTED isolation level, my application sometimes falls victim to the dreaded "lost update" condition where two of my users edit the same row for update but the user who submits his/her change last overwrites changes made by the other user. Is there a good way to check for this and prevent it?
2008-06-02
3,771 reads
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
41 reads
In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
2008-06-02
2,812 reads
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
39 reads
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
40 reads
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
45 reads
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
31 reads
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
42 reads
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
35 reads
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
50 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers