Questions tagged [enterprise-edition]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
450 views

Availability group/Failover cluster failing without signs of errors

So this is the second time it happens. Specs: SQL Server 2014 Enterprise Failover Cluster with 2 nodes No Quorum ( I Think ) Event Viwer has some events as follow: The information one always ...
4
votes
0answers
273 views

Online index rebuild higher fragmentation on intermediate level

I need to rebuild some big indexes and I'm doing some tests with the various options (sort_in_tempdb, maxdop, online) of the ALTER INDEX statement on an test index with 4 levels and 800000 pages on ...
2
votes
0answers
94 views

SQL Server: Read Only replica of production server

I have a production database which is being used by my primary application. Another department has created a new application for which I need to provide subset of my data from my database. The new ...
1
vote
0answers
50 views

How do SQL Server users deploy for different licenses of the same release of SQL Server?

Let's assume I want to deploy something like this to SQL Server, ALTER TABLE foo ALTER COLUMN a varchar(11) NOT NULL WITH (ONLINE = ON); This will work fine if your version of SQL Server is "...
0
votes
1answer
29 views

High Availability with Transactional Replication

We are using SQL 2017 Enterprise and setting up a new DR site. One of our servers (Server B) is used for reporting and has many databases, one of which has tables populated through Transactional ...