New answers tagged

0

Set up SQL Server AlwayOn with read-only Replicas You can set SQL Server AlwayOn with read-only Replicas somewhat easily. It's a shared nothing environment, but you will have to cluster all nine nodes--primary plus eight secondary replicas (1+8 max as of SQL Server 2016) https://msdn.microsoft.com/en-us/library/hh510230.aspx. You can try a simple test with ...


5

You are performing an index rebuild on Standard edition. As documented here you would need Enterprise or Developer edition to see parallelism for this.



Top 50 recent answers are included