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
238 views

In SQL Server, what is “Partitioned Table Parallelism” that is only available in Enterprise Edition?

I am reviewing the differences between Standard and Enterprise editions of SQL Server and can't reproduce the differences advertised in this demo that explains the differences - the performance I ...
5
votes
1answer
296 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
157 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
61 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
44 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 ...