Tag Archives: sql server

If You Build It, Will They Use Linux?

Posted on September 22, 2023 by way0utwest

There’s a great scene in Field of Dreams where James Earl Jones says that people will come. It’s in response to the voices Kevin Costner hears early in the movie. This is the climax of the movie, where Costner makes … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

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 , | 3 Comments

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 , | Comments Off on Capturing Data Changes

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 | Comments Off on Nested Transactions