Questions tagged [enterprise-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
21
votes
3answers
18k views

varchar(255) or varchar(256)?

Should I use varchar(255) or varchar(256) when designing tables? I've heard one byte is used for the length of column, or to store metadata. Does it matter anymore at this point? I saw some posts on ...
8
votes
3answers
549 views

Using SPID in DB Tables (instead of Table Variable)

Transactional database used for booking things... Our vendor was asked to replace #temptables with @tablevariables (because of heavy compile locks) but instead they replaced with an actual table ...
8
votes
2answers
656 views

SQL Server 2016 Enterprise poor performance

Sorry to be long, but I want to give you as much information as possible so that might be helpful to the analysis. I know there are several posts with similar issues, however, I have already followed ...
7
votes
2answers
3k views

Finite State Machines in SQL

I'd like some input on an issue I'm having. We have a section of code that we repeat throughout our stored procedures, and every time it takes quite some time to process, and when combined the number ...
6
votes
3answers
170 views

Manipulating a Column Containing Key/Value Pairs

I'm accessing and creating reports from a vendor via a replicated SQL Server database. They've done some absolutely insane things that I've been trying to solve for, but this one takes the cake. ...
4
votes
2answers
4k 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 ...
4
votes
1answer
272 views

Ship Standby Logs Without Datafiles

When building a new standby database, is it possible to have it start shipping archive logs from the primary without having the datafiles on the standby yet?
4
votes
2answers
413 views

Can SQL Server R Services be enabled on a readable secondary?

To avoid excess load on the primary SQL Server, I'd like to install and enable R Services on a secondary replica of the primary server. Is this possible? Also, can I push computations from a remote R ...
4
votes
0answers
242 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 ...
3
votes
1answer
96 views

SQL Server 2008 R2 Edition Upgrade Process

I have several SQL Server 2008 R2 Standard Edition instances that we need to upgrade to SQL Server 2008 R2 Enterprise Edition. If I have valid SQL Server 2017 Enterprise Edition (with SA) PIDs, do I ...
3
votes
2answers
772 views

SQL Server R Services - Could not find stored procedure 'master..xp_ScaleR_init_job'

I'm trying to run a data science experiment as explained in this tutorial. The tutorial has 5 lessons, and each lesson has a few sub-sections in it. For this tutorial, I am using a SQL Server 2016 ...
3
votes
1answer
301 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 [...
3
votes
0answers
117 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 ...
2
votes
2answers
13k views

Downgrade SQL Server Enterprise Edition to SQL Server Standard Edition

There is a requirement in our project where they want to evaluate if it is possible to downgrade SQL Server from Enterprise to Standard edition and if a server can be decommissioned. How can I ...
2
votes
1answer
104 views

Using Standard Edition for a VLDB

In order to save licensing costs I'm evaluating whether I can get away with Standard Edition for a VLDB. I'll outline the scenario: Here, "VLDB" means 5TB. The size is expected to be stable over time....
2
votes
1answer
59 views

Dropping historic Partitions that are no longer required while in P2P replication

The Company I work for has a set of databases (largest just below 1Tb) on different servers - 2 in the US, 2 in Europe. We run full peer-to-peer replication per database between the 4 nodes - so they ...
1
vote
1answer
1k views

SQL Server Editions: Backup restore of Enterprise Edition 2014 on Standard Edition 2017

I know, this kind of question has already been answered some times but I don't find some current answers and wonder if SQL Server Standard Edition 2016 SP1 has changed something in the matter as it ...
1
vote
2answers
388 views

Primary keys, clustered indexes and partitioning

We store data for financial records, splitting it up over 4 tables. I'm at a bit of a loss as to what's optimal for our setup here, or at least which direction to head in as I'm getting a lot of ...
1
vote
1answer
264 views

Transactional Replication Synchronization taking too long to respond

I successfully generated the snapshot, but subscription is not working correctly. Either the synchronization takes too long to respond or it simply displays the text shown in below attached screenshot....
1
vote
1answer
236 views

MySQL Enterprise Connector/PHP Plugin for php 5.4 [closed]

I'm trying to setup mysqlenterprise.so. I have installed the native driver and loaded before mysqlent, but when I try to start it I got: Starting php-fpm: [14-Jul-2015 14:27:40] NOTICE: PHP message: ...
1
vote
1answer
23 views

Auditing of modification of change to encryption keys

Is it possible to audit/log any attempts or actual changes to the keys used in the encryption hierarchy? We are using 2014 Enterprise edition and have recently enabled TDE across our databases and ...
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
75 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 ...
0
votes
1answer
72 views

One time database shrink catch-22 solution?

I am developing a plan for SQL Server 2012 EE to properly downsize and type (nchar to char types) some needlessly Unicode nvarchar(max) fields and would like to optimize the database size as part of ...
0
votes
1answer
31 views

Modifying Schema on secondary replica

I am looking for a solution for a secondary replica change. I have a vendor database that uses memory optimized tables. I am trying to find a solution that would allow the In Memory tables be ...
0
votes
1answer
100 views

Why is our SQL Server instance writing a mystery text file to our C: drive?

On a dev-test WINTEL server, our C: drive has almost run out of disk space due to a SQL.LOG file that is 133 GB in size. I used SysInternals Handle.exe tool to determine which process was writing this ...
0
votes
1answer
29 views

Upgrade/Transition Path from MySQL Community 5.6.31 to Enterprise

Full disclosure. I have never upgraded a database. I have a MySQL Community that is not the latest @5.6.31 ( latest is 8 ?) to the paid, Enterprise version. We will ask Tech Support once purchase of ...
0
votes
1answer
90 views

How to find the erroneous code failing the SSDT publish?

Every time something fails the publish, assuming it passes the preview generation, the error line and executed script sample are completely useless at helping me trace the source of the error, since ...
0
votes
2answers
2k views

Can partitioning help speed up inserts on a very large table?

Some background: SQL 2012 Enterprise OLTP table currently at 1B records records increase 5-10M per day SAN lun with flash storage two indexes (one clustered identity int) What we have noticed is a ...
0
votes
0answers
51 views

Can we find who killed a SQL Server process? [duplicate]

I am using SQL Server 2012 Enterprise Edition. We are running SSIS package which usually take more than 5 hours to complete execution. Some time we find that the transaction is being killed by someone ...