Tag Archives: sql server

Has SQL Server Performance Improved?

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

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

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

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