Questions tagged [standard-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
40 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 ...
0
votes
2answers
81 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 ?
0
votes
4answers
153 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,...
3
votes
1answer
94 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 ...
1
vote
1answer
94 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 ...
3
votes
1answer
275 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 ...
2
votes
3answers
166 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 ...
1
vote
1answer
66 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 ...
2
votes
2answers
589 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 ...
1
vote
1answer
124 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 ...
4
votes
2answers
3k 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
2answers
653 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 ...
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 ...
3
votes
1answer
2k 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 : ...
0
votes
1answer
548 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?
1
vote
2answers
2k 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 ...
5
votes
2answers
490 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 ...
2
votes
1answer
1k 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 ...
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 ...
0
votes
1answer
186 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 ...
0
votes
1answer
113 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 ...
0
votes
1answer
408 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....
0
votes
1answer
2k 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 ...
3
votes
1answer
63 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 ...
4
votes
1answer
1k 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 ...
0
votes
1answer
175 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 ...
6
votes
1answer
158 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 ...
1
vote
1answer
320 views

Replication To Enterprise & Standard Edition subscribers

We have a defined and well running transactional replication process. One publisher, one distributor (on separate servers) and several subscribers (pull). All servers have Enterprise Edition. Latency ...
3
votes
2answers
5k views

Sql Server - How to convert Audit log into a table?

I am using Sql Server 2014, Standard Edition. My objective is to trace the history of operations on the tables (insert, update, delete), and to display on the web so the users are able to tell what ...
3
votes
2answers
2k views

Multiple Basic Availability Groups and Performance - SQL Server

I'm migrating some of my company's SQL Server boxes to a new SQL 2016 setup. We're currently using database mirroring on SQL 2012. One of the instances I'm migrating currently has about 60 databases ...
3
votes
3answers
1k views

Install Express/Standard side-by-side

I've reviewed these two existing questions: Install SQL Server 2008 Express on same machine as normal SQL Server 2008 install? Installing SQL Server Express in parallel of Standard ...and I believe ...
1
vote
1answer
100 views

What options are there for rebuilds of indexes on large tables for a data warehouse?

I have a bulk loading process that loads millions of records into a few fact tables within a warehouse. Those tables are primarily clustered on time. The non-clustered indexes are in place for how the ...
0
votes
1answer
4k views

Rebuild Indexes on SQL Server Standard edition

We have SQL Server 2008 R2 Standard on a Windows Server cluster. I want to defrag all indexes on a database. What is the best approach to disable all connections and allow the rebuild of indexes? ...
0
votes
0answers
18 views

Options for reducing transaction log size when disk space is restricted [duplicate]

I have a very unfortunate situation in which I have some SQL Server (standard edition) databases living on a small (~120gb) disk, and a transaction log which has grown to 50gb+. Unfortunately, the ...
4
votes
1answer
2k views

Understanding DBCC CHECKDB, Snapshots, and SQL Server Standard Edition

Understanding the circumstances under which SQL Server creates a snapshot when running CHECKDB, I followed a link to this KB that states: Database snapshots are available only in SQL Server ...
6
votes
2answers
1k views

SQL Server 2012 Standard Edition Disaster Recovery Options?

Suggest me the best method for My DR plan. Currently we have set of databases (6) used for our application and we in the process of building DR and HA plan. As we are into small business we are using ...
2
votes
3answers
2k views

SQL Server Standard edition attach partitioned database

I have a little problem. I'm using a SQL Server database version 11. I have to change database edition from enterprise to standard. I overlooked fact that standard edition doesn't have partitioned ...
1
vote
1answer
233 views

SQL Licensing on Azure, Standard D4 Windows 2012 Server 8 core, is it 1 phsysical core?

I am trying to calculate my costs for Microsoft Azure. Imagine I take a Standart D4 Type machine running Windows 2012 and would like to install my own SQL Server 2012. Are these 8 cores 1 quad core ...
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 ...
0
votes
0answers
1k views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
0
votes
1answer
193 views

Licensing of Oracle Standard One multiple homes [closed]

we I have a server with Oracle SE One ... I need to separate the test data from prod data as each one has it's own schema, I will do 1 of 2 which is both are OK for the dev team: Create a new ...
1
vote
1answer
131 views

Is there a common approach to encrypting data at the database level?

Is there a common approach to encrypting data at the database level? The application I am working on will be storing sensitive data that only users of the system themselves will be able to view.