The Slow Upgrade of SQL Server Versions
It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.
2021-08-16
335 reads
It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.
2021-08-16
335 reads
2019-08-12
269 reads
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
247 reads
Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.
2023-07-26 (first published: 2019-05-03)
374 reads
2018-04-13
773 reads
In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.
2013-08-20
3,527 reads
You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.
2010-09-24
4,416 reads
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
2009-05-08
13,689 reads
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
2009-04-09
2,403 reads
While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.
2009-03-19
3,154 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
By Rohit Garg
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers