Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [enterprise-edition]

57 questions
34
votes
3 answers

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 the internet, however they apply to Oracle and…
user129291
8
votes
2 answers

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 devs can trigger some enterprise features…
Jack Garbiec
  • 83
  • 4
8
votes
3 answers

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. They have a table that has many standard columns. But…
Andy
  • 193
  • 1
  • 1
  • 7
8
votes
3 answers

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 that adds SPID as a column to ensure the stored…
outjet
  • 183
  • 4
8
votes
2 answers

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 these various posts and other information…
Nelson Lopes
  • 111
  • 9
8
votes
2 answers

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 of reads runs into the hundreds of millions on a…
Maj0r
  • 116
  • 1
  • 6
7
votes
1 answer

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 observe when running a query across Standard and…
ruskind
  • 253
  • 1
  • 4
7
votes
2 answers

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 that caught my eye were: Online indexing Online…
J.D.
  • 40,776
  • 12
  • 62
  • 141
6
votes
1 answer

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 takes 1 second but now It took 20 seconds. I found…
Gio
  • 71
  • 1
  • 2
6
votes
1 answer

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 leaf level. I noticed when I'm running the…
Frederik Vanderhaegen
  • 2,122
  • 1
  • 17
  • 36
4
votes
2 answers

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 need to create 1 or 2 more reports. I use SQL Agent…
Racer SQL
  • 7,546
  • 16
  • 77
  • 140
4
votes
1 answer

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
  • 23,884
  • 17
  • 80
  • 155
4
votes
2 answers

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 client onto the secondary server with R Services…
Minu
  • 391
  • 1
  • 13
3
votes
1 answer

Can we downgrade edition from SQL Server 2016 Enterprise to Standard when we have compression feature enabled?

I have a production database running on SQL Server 2016 Enterprise. I ran the below query to check the edition-specific feature and see the compression feature in use. Can we still downgrade the edition? Query SELECT feature_name FROM…
Vikas Kanoujiya
  • 31
  • 1
3
votes
1 answer

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 need to have SQL Server 2008 R2 Enterprise Edition…
Ray
  • 433
  • 3
  • 5
1
2 3 4