Tag Archives: sql server

Has SQL Server Performance Improved?

Posted on April 1, 2023 by way0utwest

I saw a very interesting blog post this week from Brent Ozar that asked if SQL Server 2019 More CPU-Intensive Than SQL Server 2016? You can read the post, but a client was having CPU issues and thought everything between … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Capturing Data Changes

Posted on March 27, 2023 by way0utwest

While working with a customer recently, I saw some code from them that used the OUTPUT and INTO clauses of an UPDATE statement to capture the changes made into another table. In this case, as users updated code strings in … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Nested Transactions

Posted on March 6, 2023 by way0utwest

One of the very common expectations from many SQL developers involves transactions. Many developers (database or application developers) think they can open a transaction, do something, open an inner transaction (nested), and then commit or rollback the inner transaction separate … Continue reading →

Posted in Editorial | Tagged | Leave a comment

The Top SQL Server Engine Errors

Posted on March 4, 2023 by way0utwest

For many of us, SQL Server just works. We might get some syntax errors if we mistype things, but for the most part, SQL Server runs smoothly in many environments. However, there are some common situations that do occur regularly, … Continue reading →

Posted in Editorial | Tagged , , | 1 Comment