All Questions
Tagged with standard-edition sql-server-2017
7 questions
7
votes
2
answers
11k
views
SQL Server 2017 Enterprise vs Standard - Online Indexing and Online Schema Change
I read through Microsoft's "Editions and supported features of SQL Server 2017" doc to compare the feature differences between Enterprise and Standard edition.
Two things not available in Standard ...
- 39.5k
4
votes
1
answer
183
views
Distributed AG on SQL Server 2017 Standard Edition?
Can I configure Distributed AG with SQL Server 2017 Standard Edition?
1
vote
2
answers
4k
views
SQL Server Standard Basic Availability Group - only 10 Listeners limit?
Is there a limit to the number of listeners that can be created using SQL Server Standard?
I'm working with a DBA who has set up a 2017 Standard server, with CU3. We have 12 databases, and he was ...
- 53
0
votes
2
answers
80
views
Configure Always On to use secondary site as DR
I have two SQL Server 2017 Standard Edition clusters, each in a different datacenter, only a pair of servers each.
I was able to configure and test the Windows Cluster, Quorum for it, AG, including ...
0
votes
1
answer
109
views
Unable to force a query store sql plan in Principal DB
I have a SQL 2017 mirroring setup and found a query has 2 plans in query store and I wanted to force the good plan which runs much faster. But when i force the query plan I get below error. Same error ...
0
votes
1
answer
383
views
Wait time on server replies is sometimes very long when running the query over and over
As seen in this screen shot, I'm running the same query over and over again, comes back with 0 rows (as expected). For some reason I'm seeing very large wait times on server replies while running this ...
- 53
0
votes
2
answers
182
views
On update: Login failed for SQL Server authenticated sysadm
I run into a weird bug?
User complained to me that he cannot anymore update certain tables in database. He had owner rights in database and the login was window login (ad-login). I tried elevating him ...
- 101