Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [enterprise-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
36 views

Upgrade SQL Server Server Express to Licensed Enterpise edition?

we have sql server express edition 2017 with default instanc ,now we want to upgrade it to Enterprise Licensed Edition 2017 with default instance in the same server At first I thought I had to ...
yamihero777's user avatar
0 votes
0 answers
42 views

sqlserver alwayson audit setting

I am running SQLSERVER ALWAYS ON 2019 ENT VERSION. I'm trying to STOCK an audit at the database level in SQLSERVER. In the master, it was confirmed that the log audit was left at DATABASE LEVEL. ...
user avatar
1 vote
2 answers
336 views

SQL Server database with 100 terabyte of data

We have been assigned a new application where the vendor is expecting the database to grow to around 100 TB. They have mentioned SQL Server Standard Edition is compatible. My question is whether SQL ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
0 answers
166 views

Improving Query Performance on Non-Indexed Single HEAP File DB

My teammates and I often have to write queries that revolve around a database that is not partitioned (a single heap file) and has no index. I was told by the DBA that this won't change. Are there ...
MCP_infiltrator's user avatar
0 votes
0 answers
42 views

How to improve rows estimating

I have a query from thirdparty app to our tables. The problem is that execute takes up to 10 minutes. Here is the plan of long execution https://www.brentozar.com/pastetheplan/?id=r1_tLDGHh As I see, ...
Novitskiy Denis's user avatar
2 votes
1 answer
708 views

SQL server wont start automatically after OS upgrade

I did an in place upgrade for host OS from Windows server 2012 R2 to windows server 2022. After this move, I noticed the SQL server 2017 enterprise edition instance therein does not start ...
franklwambo19's user avatar
0 votes
0 answers
73 views

Update stats for ETL tables

There is a huge table with more than 2 tb size . Etl algorithm is as below, if new scenario it will insert millions of data in partition table 2)if old scenario it will reimport & delete older ...
Vishal 's user avatar
0 votes
0 answers
31 views

Looking to find a working download to view or change DTS

I am new to working with databases and have inherited some legacy internal applications. These applications rely on a job that run daily to import data from excel into a database to get new data into ...
J.L.'s user avatar
  • 1
0 votes
1 answer
255 views

In one of the Table index size is 1.6 TB, we are not able to Rebuild that index

In Sql server 2017 Enterprise Edition, one of our Clustered Indexes is more than 1.6 TB. We are unable to rebuild this index, it is failing while rebuilding due to log file full. We have added ...
DBA_Fresher's user avatar
2 votes
1 answer
223 views

Isolation Level Conflict

Hi i was asked to look at a third party app recently. There were a few queries doing giant reads and that was easy enough to fix. However, while i was working on the queries i kept seeing different ...
Simon Bradley's user avatar
1 vote
2 answers
2k views

Memory utilization by SQL Server 2016 [duplicate]

I am running a SQL Server 2016 Enterprise Edition on Windows Server, with 128 GB of memory. During installation, I assigned 124 GB to the SQL server, since the server is dedicated to SQL only, leaving ...
Nidhi 's user avatar
  • 11
0 votes
0 answers
214 views

MSSQL Server Resource Governance alternative

I've been looking into solutions for managing CPU sharing over multiple apps accessing the same SQL server database engine.I found that Resource Governance is one perfect way for me to define those ...
Hasan Baidoun's user avatar
0 votes
0 answers
56 views

SQL server encryption

i am using SQL server enterprise edition V.2019 i need to encrypt some columns i liked IBM Guardium for File and Database Encryption but the cost is too high . so i found some other solutions 1- SQL ...
Tala 's user avatar
  • 41
2 votes
1 answer
343 views

Oracle: Decreasing PCTFREE on large table

Question about Oracle Database Enterprise Edition version 19.10.0.0.0 running as a standalone instance. I have a table with billions of rows. The table has always had PCTFREE set to 10. It turns out ...
Kebs's user avatar
  • 31
0 votes
1 answer
304 views

How can I measure the impact of queries with errors being rejected by SQL Server?

After configuring XE on November 23, 2020 to capture some errors I could count 2,163,665 occurrences of the same error coming from requests of a legacy app (that probably won’t be corrected so soon). ...
Ronaldo's user avatar
  • 5,091
0 votes
1 answer
114 views

can you setup replication on mirrored SQL database

Just moved to SQL2017 Ent. Currently, do transactional replication for 1.5TB DB. the replicated database is used for data analytics, mainly Power BI reports. Need near real-time data. When I have ...
spyla's user avatar
  • 1
2 votes
1 answer
3k views

How does Automatic Seeding work - Always On Availability Group

I found only these two statements from BOL regarding this Initial Data Synchronization method: Link 1 Automatic seeding uses the log stream transport to stream the backup using VDI to the secondary ...
Rauf Asadov's user avatar
  • 1,273
1 vote
1 answer
496 views

Nonclustered Index Rebuild Online on Heap Table

Recently read that rebuilding a heap online in SQL Server Enterprise is single threaded and does not go parallel. My question is: If you try to rebuild online just non-clustered indexes on a heap ...
Corey Hambrick's user avatar
7 votes
1 answer
2k 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 ...
ruskind's user avatar
  • 253
4 votes
2 answers
1k views

what is the best approach to send report by Email?

I've been requested to create some sql server reports ( create a report and send them by email ) for some poeple. I thought it would be like 2 or 3 but now that they know I can do it, every week I ...
Racer SQL's user avatar
  • 7,386
0 votes
1 answer
250 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 ...
Michael F's user avatar
0 votes
1 answer
323 views

Distributed Always-On without Domain

We have a requirement to configure a distributed availability group from Data center1 to Data Center2 using SQL Server 2017 Enterprise Edition. DC1 (two nodes WSFC setup): SQLDB1, SQLDB2 DC2 (two ...
Sridhar G's user avatar
8 votes
2 answers
1k views

Is it possible to accidentally use some paid feature in Oracle XE database while in an Enterprise environment?

IT in my org are wary about approving me installing Oracle Express Edition. https://www.oracle.com/database/technologies/xe-downloads.html Their reasoning is that apparently some DBA once said that ...
Jack Garbiec's user avatar
6 votes
1 answer
2k views

Exactly same query and plan but different duration and total reads. I Know parameter sniffing but

I know what is parameter sniffing but this seems different, I have this simple query: select * from A400RDATA This table has only a cluster index and approximately 25000 rows. The query usually ...
Gio's user avatar
  • 71
2 votes
0 answers
1k 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 ...
Kartikeya's user avatar
8 votes
3 answers
9k 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. ...
Andy's user avatar
  • 193
8 votes
3 answers
1k 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 ...
outjet's user avatar
  • 183
3 votes
1 answer
160 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 ...
Ray's user avatar
  • 433
1 vote
1 answer
93 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 ...
benni_mac_b's user avatar
0 votes
1 answer
104 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 ...
TallKewlOnez's user avatar
1 vote
0 answers
105 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 "...
Evan Carroll's user avatar
  • 63.6k
0 votes
3 answers
6k views

Database Blocking, kill the session which is responsible after 5 minutes

I have been struggling with database blocking at my database server from last so many months. Have tried to use many ways to capture them and also aware that who are leaders of blocking. This ...
Learning_DBAdmin's user avatar
0 votes
1 answer
266 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 ...
R Farr's user avatar
  • 1
1 vote
1 answer
901 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....
dbadmin's user avatar
  • 15
0 votes
1 answer
401 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 ...
Elaskanator's user avatar
3 votes
1 answer
654 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 [...
mathewb's user avatar
  • 1,144
7 votes
2 answers
10k 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 ...
J.D.'s user avatar
  • 37.9k
1 vote
2 answers
246 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 ...
jericzech's user avatar
  • 945
6 votes
1 answer
618 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 ...
Frederik Vanderhaegen's user avatar
8 votes
2 answers
1k 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 ...
Nelson Lopes's user avatar
1 vote
2 answers
5k 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 ...
Martin Guth's user avatar
34 votes
3 answers
52k 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 ...
user avatar
4 votes
1 answer
393 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?
Leigh Riffel's user avatar
  • 23.9k
0 votes
1 answer
202 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 ...
SQLServerVillain's user avatar
1 vote
2 answers
9k 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 ...
Josh's user avatar
  • 55
4 votes
2 answers
469 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 ...
Minu's user avatar
  • 391
3 votes
2 answers
2k 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 ...
Minu's user avatar
  • 391
1 vote
2 answers
779 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 ...
Maj0r's user avatar
  • 116
8 votes
2 answers
5k 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 ...
Maj0r's user avatar
  • 116
2 votes
1 answer
124 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....
boot4life's user avatar
  • 1,279