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?
Scott PletcherConnect With a Mentor Senior 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.
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Blue BerryAuthor Commented:
Where do I start in that link :(
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 CieslikConnect With a Mentor IT 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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.