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

Questions tagged [standard-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
58 views

How is basic availability group able to auto failover without a cluster?

I have recently learnt that the SQL server standard edition's basic availability group doesn't require a windows cluster. Basic AG is considered equivalant to the deprecated mirroring technology. Like ...
variable's user avatar
  • 3,636
0 votes
1 answer
41 views

What happens when you try to use more than 32 GB of memory-optimized data in a database on Standard Edition?

In SQL Server 2019, you cannot put more than 32 GB of memory-optimized data in a database on Standard Edition. What happens if you try anyway? I'd try it myself, but I don't want to risk discovering ...
J. Mini's user avatar
  • 433
7 votes
4 answers
945 views

Is my queue table implementation race condition safe?

Hello people smarter than me! I've created a sort-of-a-queue table system, but it seems too simple to be safe from race conditions. Am I missing something or is the following race condition safe? The ...
J.D.'s user avatar
  • 37.9k
0 votes
0 answers
14 views

Running DBCC on NON-READABLE replica

Since the system databases are not duplicated in a AG environment, I want to be able to run DBCC on them on a weekly basis and I would also like to be able to run DBCC on any databases where the AG ...
Keith Clark's user avatar
23 votes
1 answer
4k views

Is "+" slower than "CONCAT" for large strings?

I have always thought that CONCAT function is actually a wrapper over the + (String Concatenation) with some additional checks in order to make our life more easier. I have not found any internal ...
gotqn's user avatar
  • 4,026
3 votes
2 answers
208 views

How to sum up the distinct Total Time of an Event ignoring duplicate overlaps in Times?

I have the following EventTimes table: DROP TABLE IF EXISTS dbo.EventTimes; CREATE TABLE dbo.EventTimes ( EventTimeKeyId INT IDENTITY(1,1) PRIMARY KEY, EventId INT NOT NULL, StartTime TIME NOT ...
J.D.'s user avatar
  • 37.9k
0 votes
1 answer
191 views

Wait time on server replies is sometimes very long when running the query over and over

As seen in this screen shot, I'm running the same query over and over again, comes back with 0 rows (as expected). For some reason I'm seeing very large wait times on server replies while running this ...
Steven M's user avatar
0 votes
2 answers
106 views

On update: Login failed for SQL Server authenticated sysadm

I run into a weird bug? User complained to me that he cannot anymore update certain tables in database. He had owner rights in database and the login was window login (ad-login). I tried elevating him ...
user1054844's user avatar
12 votes
1 answer
679 views

Is there a reliable way to check if a trigger being fired was the result of a DML action from another *specific* trigger?

Is there any way to tell from within a trigger, when it gets fired, that it is being fired as the result of a DML action that occurred within another specific trigger? Any chance any information about ...
J.D.'s user avatar
  • 37.9k
0 votes
1 answer
99 views

Unable to force a query store sql plan in Principal DB

I have a SQL 2017 mirroring setup and found a query has 2 plans in query store and I wanted to force the good plan which runs much faster. But when i force the query plan I get below error. Same error ...
udhayan dharmalingam's user avatar
0 votes
3 answers
124 views

Poorly Performing Query with Massive Misestimates

I have been looking at this statement for the last day but I've been unable to work out the best way to improve it. So, I thought I would reach out to the wider community for some advise. SELECT [FLD6]...
Tom's user avatar
  • 191
-1 votes
1 answer
158 views

When DML and DDL changes occur on a Temporal Table do the correlating changes in the History table get logged in the Transaction Log as well?

When DML and DDL queries are executed against a Temporal Table, those changes are appropriately propagated to the correlating History table. E.g. an UPDATE to the Temporal Table results in a new ...
J.D.'s user avatar
  • 37.9k
1 vote
2 answers
616 views

Replicate one database in one server to 2 other servers SQL2008

In product ion, we have a transactional replication between 2 servers with data from one database going from server A to Server B. We now want to add another server C for the short period of time ...
mail_sady's user avatar
0 votes
0 answers
213 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
4 votes
0 answers
756 views

How to debug the cause of my suddenly extremely slow running backup maintenance plan? [closed]

Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server 2016 Standard Edition instance running on a virtual machine from VMWare. @@Version: ...
J.D.'s user avatar
  • 37.9k
0 votes
0 answers
248 views

Is it safe to run DBCC CLEANTABLE on a production database?

I recently changed an application from storing images in a varbinary(max) column to cloud storage and migrated the data and removed the column. These images accounted for about 350GB of space in the ...
Brandon's user avatar
  • 151
0 votes
1 answer
1k views

What happens to a SQL Server 2019 Standard instance with an Annual Subscription Licence when it expires?

We have 3 production SQL Server 2019 standard instances which we have licenced through a third party supplier on an annual subscription basis. In our use case this works out cheaper if you only ...
Ollie's user avatar
  • 738
0 votes
2 answers
182 views

SQL Server Standard Edition CPU + Tempdb Configuration

I have SQL 2014 sp3 (Standard) With below CPU Details according to 8 CPU we have configured 8 Tempdb datafiles. Based on my configuration could you please suggest what should be the CPU & Tempdb ...
Manish R's user avatar
1 vote
1 answer
62 views

Is it possible to have something like Union-FS for Oracle databases?

I wonder if it is possible to have something like what Union-FS is for filesystems also for databases? Usecase You have a webapp (with Oracle as database in the backend) with several instances: One ...
Thomas B's user avatar
  • 121
0 votes
1 answer
64 views

Can't help the engine to choose the correct execution plan

The stuff are pretty complex to share the original code (a lot of routines, a lot of tables), so I will try to summarize. Environment: SQL Server 2016 standard edition Objects: wide table with ...
gotqn's user avatar
  • 4,026
0 votes
2 answers
73 views

Configure Always On to use secondary site as DR

I have two SQL Server 2017 Standard Edition clusters, each in a different datacenter, only a pair of servers each. I was able to configure and test the Windows Cluster, Quorum for it, AG, including ...
Luis Agustin Azario's user avatar
4 votes
1 answer
179 views

Distributed AG on SQL Server 2017 Standard Edition?

Can I configure Distributed AG with SQL Server 2017 Standard Edition?
Luis Agustin Azario's user avatar
1 vote
2 answers
3k views

Failed to create appdomain "master.sys[runtime].2"

I am getting this error in SQL Server log: Failed to create appdomain "master.sys[runtime].2" Could not load file or assembly System.Data. Not enough storage is available to process this ...
Pravin's user avatar
  • 111
3 votes
1 answer
655 views

SQL Server secondary replica snapshot with Basic Availability Group

I have the following scenario: I created an HA group of two nodes in SQL Server 2016 Standard (which is limited to two nodes, one database per group and a non readable secondary replica). I tried to ...
olimpiu rapan's user avatar
3 votes
2 answers
15k views

Developer Edition vs Standard Edition

Is it dangerous to have dev environment with a Developer Edition and Live with Standard Edition, are the binaries different ?
user1083182's user avatar
0 votes
4 answers
2k views

SQL Server 2017 Express faster than Standard Edition [closed]

What could explain SQL Server Express Edition being much faster than Web / Standard Edition? These are multiple VMs in cloud hosting. They all experience the same problem. Some are on SQL Server 2012,...
Lambda's user avatar
  • 101
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
2 votes
1 answer
961 views

Only SQL Server Enterprise Edition supports compression - how to work around that?

I have a script that needs to create a temp table and in that temp table I create an index. I noticed in some of my servers, the script would go on forever, and when checking from a different session ...
Marcello Miorelli's user avatar
3 votes
1 answer
2k views

SQL Server 2016 with high tempdb usage and low RAM usage

I've got a small instance of SQL Server Standard that I'm running HammerDB TPC-H (1 GB) benchmarks on. It's got some configuration issue though where it's writing everything into tempdb on disk, and ...
Cpt.Whale's user avatar
  • 155
2 votes
3 answers
2k views

Initial Database Size Too Big

I have a clustered SQL 2016 standard database. It is set up in a virtual environment with a total of 250 GB of storage. However, my developer set the initial size of the databases to be 100 GB. There ...
Lane J's user avatar
  • 21
1 vote
1 answer
191 views

Log shipping from SQL Server 2014 Enterprise db to SQL Server 2017 Standard with partitioning

I wish to implement log shipping from my current primary which is a SQL Server 2014 Enterprise database to a SQL Server 2017 Standard edition database. I also wish to implement table partitioning on ...
PaulAsa's user avatar
  • 11
2 votes
3 answers
2k views

Backup Performance best practices

I'm in the process of re-writing our maintenance plans and at the moment the focus is backups. Whilst preparing this plan, I'd like to try and ensure that procedures are in place to ensure that backup ...
Krishn's user avatar
  • 373
1 vote
1 answer
240 views

SQL Server 2014 Edition Downgrade

I have a SQL Server 2014 Standard Edition used by my devs to test their applications pointing to a common instance. Lately I've been informed that for this purpose I can use Developer Edition, that it ...
Carbon's user avatar
  • 13
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
4 votes
2 answers
1k views

Can anyone recommend an encryption method for ALL user dbs using SQL Server 2016 STANDARD edition?

Our clients are insisting that we now encrypt ALL their SQL Server data at rest, which must include tempdb. I think I have the following options available – Bitlocker entire drive(s) TDE (but the ...
Geebs's user avatar
  • 41
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
3 votes
1 answer
3k views

Microsoft SQL Server 2016 Service Pack 1 (SP1) support for TDE (transparent data encryption)

Does Microsoft SQL Server 2016 Service Pack 1 add support for TDE (Transparent Data Encryption) to Standard Edition as well? As per What's new in Database Engine - SQL Server 2016 and A Big Deal : ...
AUR's user avatar
  • 133
0 votes
1 answer
945 views

Can I Configure Enterprise Manager Cloud Control on Standard Edition

Is it possible to configure enterprise manager cloud control on Oracle 12c Standard edition? Will it administer multiple databases (Non-CDB)? What about administering databases on different servers?
Husam Mohamed's user avatar
1 vote
2 answers
4k views

SQL Server Standard Basic Availability Group - only 10 Listeners limit?

Is there a limit to the number of listeners that can be created using SQL Server Standard? I'm working with a DBA who has set up a 2017 Standard server, with CU3. We have 12 databases, and he was ...
Rekonn's user avatar
  • 53
6 votes
3 answers
2k views

Deleting data from a table containing LOBs did not reduce the amount of data reported INTERNALLY by the table or database

Running SQL Server 2012 standard, using both replication data and log shipping. Transaction log backups are created every few minutes. This question is NOT about the amount of space reported by the ...
P Hinman's user avatar
  • 161
2 votes
1 answer
2k views

How to Store Text Reports in a Database [duplicate]

I have dozens of text reports that come in every day and I need to store them. I cannot just zip them and put them on the hard drive because the users aren't sophisticated enough to figure that out. I ...
Missy's user avatar
  • 195
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
0 votes
1 answer
270 views

Why my indexes monitoring status change to 'no'?

On one of my production Oracle database 11g Standard Edition I have a lot (a very lot of) indexes. Some of them (majority) are created by the application installer, others are created by me when I ...
tdaget's user avatar
  • 813
0 votes
1 answer
150 views

Optimal data type for storing numbers in SQL Server [closed]

Similar to varchar that stores strings of varying length, is there an alternative for numbers of varying length that allocates space depending on the size of the number? I have a large table with 50 ...
rsreji's user avatar
  • 11
0 votes
1 answer
800 views

Unable to start the SQL Server Agent

I am unable to start then SQL Server Agent. I am getting the below error message when I tried to start the agent: The SQL Server Agent service (DB_NN) on local machine was started and then stopped....
kumar's user avatar
  • 161
0 votes
1 answer
13k views

How to capture all user's query on Oracle database

I have an Oracle Database installed over Unix system. On this single instance database I have a lot of sessions opened from an application pool (application is installed on another server). Every ...
tdaget's user avatar
  • 813
3 votes
1 answer
105 views

Xp_delete deletes old backup even when the backup job failed

I run the following scripts for a backup job. After the backup job completes, (xp_delete) deletes the old copy of full backup. Typically, if the backup fails the BACKUP DATABASE statement on the 2nd ...
john's user avatar
  • 31
5 votes
1 answer
2k views

Simulate production workload on test environment [duplicate]

We are on SQL Server 2008 R2 Standard Edition. Some tables are highly fragmented. I want to see if defragmentation will improve performance and is worth the effort and tables/indexes being locked ...
Stackoverflowuser's user avatar
0 votes
1 answer
256 views

Redo log member and control files at Oracle DB Standard Edition

I am planing to dive into the oracle database world. Since the oracle database is such a complex machine, I want to inform myself as good as possible, before I start. I have some questions. How many ...
SethM's user avatar
  • 1
6 votes
1 answer
171 views

Read-ahead reads and SQL-Variant fields

I have two tables containing exactly the same data. Both table have bigint primary key identity column, 60 columns and 300 000 rows. The difference is that all of the columns of the second table have ...
gotqn's user avatar
  • 4,026