Questions tagged [enterprise-edition]

The tag has no usage guidance.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
219 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 ...
1
vote
0answers
45 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 "...
1
vote
1answer
250 views

Restore Read Only FileGroups from File

I have a database DB in simple recovery mode with filegroups PRIMARY, A, B, and C. Each filegroup has a single file, PRIMARY.MDF, A.NDF, B.NDF, and C.NDF, respectively. First, I run: ALTER DATABASE [...
1
vote
1answer
74 views

Decision concerning RAM limit

What steps would you do to be sure that STANDARD edition with its 128GB RAM limit is enough for your production? My subjective feeling is that we are somehow on the edge and I am looking for strong ...