Dear SQL DBA cover image

Should I Upgrade to SQL Server 2016?

Dear SQL DBA

00:00

Column Store Is a Better Choice Than in Memory

Column store has a similar limit. You can use it in the lower editions, but it can only use 25 % of the buffer pool limit for that edition. And you get a limit on how many cores your queries can use against the column store object. Sequill server 20 16 r t m already had query store in all the editions, but so is ardiosom. N that column store is available there as well.

Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner