Questions tagged [sql-server-2025]
SQL Server 2025 (major build version 17.00.xxxx). Please also tag sql-server.
8 questions
1
vote
1
answer
27
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 1,398
-3
votes
1
answer
300
views
Maintenance Plan Wizard jobs all error in SQL Server 2025 RTM
Maintenance wizard jobs such as DB Integrity* or DB Reindex* or "Misc Cleanup" all error as of production RTM version of SS 2025. I know - 2 of the above jobs can also be Ola H jobs but ...
- 25
5
votes
0
answers
138
views
Does partitioning allow filegroups with LOB data to be shrunk?
It is extensively documented that shrinking any data files that have LOB pages is awful:
Microsoft says you need to read the whole partition once for every page you want to move.
The well-known ...
- 1,398
0
votes
0
answers
97
views
SQL AG with Windows Server 2025 Fail-over cluster
I wonder if anyone is up-to-date with the workings of Fail-over cluster in Windows Server 2025.
Since each version has their changes.
We are doing a test setup of 3 nodes on 1 location, 3 nodes on the ...
- 1
-2
votes
3
answers
358
views
Maintenance Plan Wizard on 2025 (R1)
I’m experiencing issues with Microsoft SQL Server 2025 (RC1) because there are no maintenance plans. It’s not a problem — I can create a job instead. However, I’d like to know how to install or enable ...
6
votes
4
answers
1k
views
Does the new locking optimization make batching unnecessary?
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 ...
- 2,295
4
votes
3
answers
281
views
Can Standard Developer Edition be used in Docker?
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 ...
- 1,398
0
votes
1
answer
175
views
Did performance when querying partitioned tables using min/max functions or TOP improve after SQL Server 2022?
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 ...
- 1,398