Questions tagged [sql-server-2025]

Optimized Locking (2025-05-19) makes it sound like batching would be unnecessary if I were to, for example, try to delete 20 thousand rows from a million row table in one statement (DELETE FROM foo WHERE Status = 1). Is that true?

I hear that the new Standard Developer edition is available in the current SQL Server 2025 preview. But how can I get it in Docker? SQL Server 2022's documentation shows us how to specify specific editions when creating a container. docker run…

With partitioned tables in SQL Server, there is a notorious major performance issue when using using min/max functions or TOP. Microsoft document workarounds for it here. I am confident that this was not fixed in SQL Server 2022. Microsoft surely…