Avatar of Blue Berry
Blue Berry
 asked on

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon
Paul MacDonald

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 Berry

ASKER
It was asked in an interview
Blue Berry

ASKER
Where do I start in that link :(
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Pawan Kumar

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-Dunne

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 Kumar

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Deepak Chauhan

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. :-)
SOLUTION
Tom Cieslik

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Blue Berry

ASKER
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 Kumar

@Author -

This is a very generalized question so we cannot pinpoint that this is the answer.  We cannot read the interviewer's mind. :)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Vitor Montalvão

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 Horn

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?
ASKER CERTIFIED SOLUTION
Scott Pletcher

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.