Buffer Pool Extensions
-
Comments posted to this topic are about the item Buffer Pool Extensions
-
Too easy thanks Steve
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
Ford Fairlane (4/16/2014)
Too easy thanks Steve+1 -this feature is difficult to miss
-
Easy one thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Thank you for the post, SJ.
(I have installed the SQL 2014 help files yesterday night locally and I had to depend on it literally to answer this question, I read the page on BPE and I was like 2014 has some really cool features and hoping one day, I mean before SQL 2020 will be released, then we, Indians, possibly will think of installing and use it
OR I can buy the developer edition and learn/improve on my own...:cool:)ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart. -
Revenant (4/16/2014)
Ford Fairlane (4/16/2014)
Too easy thanks Steve+1 -this feature is difficult to miss
+1 This is one of the main features I was looking forward to.
Everything is awesome! -
Easy (after I looked it up).
-
Wow, as I looked through the possible answers, the correct one was the one I thought was certainly wrong. I always associate buffer pool with RAM, so I wouldn't have thought extending it to physical storage would make sense. Good thing I decided to look it up before answering
Be still, and know that I am God - Psalm 46:10
-
I remembered hearing about this at PASS 2013, and remembered correctly!
Some interesting wrong choices, though!
-
Not having yet played with 2014, I learned something new. Thanks.
-
This is a great new feature in Sql Server 2014
Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)
ALTER SERVER CONFIGURATION
SET BUFFER POOL EXTENSION ON
(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50 GB);
Thanks
Igor
Igor Micev,My blog: www.igormicev.com
-
Ed Wagner (4/17/2014)
Not having yet played with 2014, I learned something new. Thanks.+1
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
Igor Micev (4/18/2014)
This is a great new feature in Sql Server 2014Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)
ALTER SERVER CONFIGURATION
SET BUFFER POOL EXTENSION ON
(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50 GB);
Thanks
Igor
+1 good example.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
Thank you! for question on new feature of SQL 2014.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't." -
easy one..
thanks steve.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply