Database 2012

Hi experts

Can you please help with this question I was asked.

What is one very important thing you can do in 2012 enterprise edition that can not be done in standard edition.
Hint: It affects tables

Thank in advance
Blue BerryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul MacDonaldDirector, Information SystemsCommented:
This sounds like a classroom question, so I'm not going to answer it, but I will give you a link showing the capabilities of the different editions of SQL Server 2012.
Blue BerryAuthor Commented:
It was asked in an interview
Blue BerryAuthor Commented:
Where do I start in that link :(
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Pawan KumarDatabase ExpertCommented:
You need this -

In Enterprise edition of SQL SERVER 2012 we can do Partitioning for both - Tables as well as indexes. This is one of the very important feature.
David Sheehan-DunneIT TechnicianCommented:
The link Paul posted will give you the information you require on the differences between standard and enterprise editions, I will give you a hint, look in the High availability table and compare the two.  Now think about what a company requires of IT, and see if any of that matches what the enterprise edition provides :)

Good luck with your interview
Pawan KumarDatabase ExpertCommented:
Adding to my previous comment.

"In Enterprise edition of SQL SERVER 2012 we can do Partitioning for both - Tables as well as indexes. This is one of the very important feature."

Note - This affect tables and very important in terms of performance.
Deepak ChauhanSQL Server DBACommented:
If you want to know from interview purpose then everything is useful in that link.. you need to read it thoroughly. so that you can compare all editions for your next interview. :-)
Tom CieslikIT EngineerCommented:
Here is your answer

Bottom line is that ENTERPRISE has NO LIMITATION (limited to server that is installed on)
Blue BerryAuthor Commented:
This is the answer they was looking for

The answer is you can NOT create or rebuild an index ONLINE.
what this means is that the table that is being indexed will be LOCKED hence applications/users will get timed out.
Any half decent DBA should know this as its one hell of an important thing.
Its the difference betwwen rebuilding an index at 2pm or 2am.
Pawan KumarDatabase ExpertCommented:
@Author -

This is a very generalized question so we cannot pinpoint that this is the answer.  We cannot read the interviewer's mind. :)
Vitor MontalvãoMSSQL Senior EngineerCommented:
IMHO that's a weak question for an interview as it can lead to multiple answers.
A good question should be:
"You're working with a Standard Edition instance and cannot upgrade it to an Enterprise Edition. How can you minimize the impact of not being possible to execute ONLINE reindexes?"
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Sounds like a Trivial Pursuit style interview.  Did he ask how many dimples are on a golf ball, or how many ping pong balls can fit in an airplane?
Scott PletcherSenior DBACommented:
By far the single biggest factor relevant to that q is:
data compression.
You can compress table data in Enterprise Edition but not in Standard Edition.

Rebuilds are not really that frequent -- or at least shouldn't be -- and should be particularly rare for large tables.  I suppose I can imagine a situation where you'd need an immediate/"emergency" rebuild, but it would be extraordinarily rare (say every year or two!).

Don't get me wrong.  Online rebuilds are great to have, but they don't begin to equal data compression for overall performance gain.  If that company is commonly or frequently doing rebuilds, they have significant table and/or index design issues.

However, it's difficult to claim any technically-correct answer is wrong given how open the q is: "one very important thing".

They should have written:
What is the most important thing affecting tables(*) which you can do in 2012 enterprise edition that cannot be done in standard edition?
" (*) Or "table performance", if they wanted to give a better hint, which they legitimately may not have wanted to do.

They're dead wrong that it's Online Rebuilds, but at least the q would be clear.  Even if the answers disagreed, you'd get a gauge of what was considered most important.  Personally, I'd know that, as a DBA, I probably wouldn't want to work there, except perhaps if fully in charge and willing to lead up a clean-up mission.

How can you minimize the impact of not being possible to execute ONLINE reindexes?"
But then you've given the answer in the q, which removes the original q.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.