BUFFER POOL EXTENSION EDITIONS

Question

Post reply

BUFFER POOL EXTENSION EDITIONS

TomThomson

SSC Guru

Points: 104773
More actions
May 8, 2014 at 12:03 am

#396722

Comments posted to this topic are about the item BUFFER POOL EXTENSION EDITIONS
Tom
May 8, 2014 at 2:49 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Rune Bivrin SSCrazy Eights Points: 8511 More actions · Answer 1

Interesting question. Too bad none of the answers are correct. BI edition does not support buffer pool extension.

Oh, and your reference link doesn't work.

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Just because you're right doesn't mean everybody else is wrong.

darkunic SSCommitted Points: 1889 More actions · Answer 2

No correct answer available

- only enterprise and standard

http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.120%29.aspx

Neil Burton SSC-Insane Points: 22999 More actions · Answer 3

I got this correct but only by virtue of an educated guess. The link to the reference doesn't work and the MSDN page suggests that there are only two editions that support it. I chose those two and then thought which would be the most likely other option.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

karthik babu Hall of Fame Points: 3335 More actions · Answer 4

Buffer pool Extn is not available in BI edition..

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 5

karthik babu (5/8/2014)
Buffer pool Extn is not available in BI edition..
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

+1

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 6

Thanks for the question, made me go have a look when I couldn't see the correct answer listed, hoping it might have changed:-D

😎

Mark Grout SSChasing Mays Points: 602 More actions · Answer 7

Mark Grout

SSChasing Mays

Points: 602

May 8, 2014 at 4:29 am

#1711795

I got confused by "suppotys"

sridhar.kapila SSC Journeyman Points: 98 More actions · Answer 8

I looked at this as well and see that only Enterprize and Standard editions have that feature. Its a nice question. I thought of Developer Edition might also fitten here.

"SQL Server 2014 Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. "

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Aleksl-294755 Hall of Fame Points: 3514 More actions · Answer 9

Interesting question, thanks Tom. Unfortunately, none of the answers are correct. Enterprise, Standard, and I assume Developer editions. This feature is only available for 64-bit SQL Server.

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

http://msdn.microsoft.com/en-us/library/ms144275(v=sql.120).aspx

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

While a good question, I also got it by luck. I won't repost the same URL as everyone else. Not supported in BI Edition.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Apologies to eveyone for the two stupid errors, one in the question and one in the explanation.

The second answer option should have read "Enterprise and Standard editions". I've asked Steve to correct it. The idea wasn't to list all the editions that support the feature (enterprise, Standard, developer, Evaluation) just to list a set which din't have any that didnýt support it, and I've no idea how I came to put BI in there - when I looked at the question today I was horrified to see it.

The link in the explanation shouldn't have "]" on the end. I've asked Steve to correct thtat too.

Once again I've demonstrated that even when trying to be careful I can mess up posing a QOTD. :blush:

Tom

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

TomThomson (5/8/2014)
Apologies to eveyone for the two stupid errors, one in the question and one in the explanation.
The second answer option should have read "Enterprise and Standard editions". I've asked Steve to correct it. The idea wasn't to list all the editions that support the feature (enterprise, Standard, developer, Evaluation) just to list a set which din't have any that didnýt support it, and I've no idea how I came to put BI in there - when I looked at the question today I was horrified to see it.
The link in the explanation shouldn't have "]" on the end. I've asked Steve to correct thtat too.
Once again I've demonstrated that even when trying to be careful I can mess up posing a QOTD. :blush:

Well said, sir. Unfortunately, we all make mistakes from time to time.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

RLilj33 SSCrazy Points: 2153 More actions · Answer 13

Thanks for the question, Tom. I appreciate that this wasn't some "trick" question. I appreciate the straight-forwardness of it.