Join Joey D'Antoni for an in-depth discussion in this video Using filtered nonclustered columnstore for HTAP, part of SQL Server Performance for Developers.
- [Instructor] So our final Columnstore topic…is going to be hybrid analytics.…This is a unique business scenario,…and I'll use a specific business as an example,…because it makes a lot of sense in terms of volume.…If you're selling tickets to a popular event,…like say a music concert, where you want to be able…to do analytics as soon as the data's into your system,…you want to see who's buying your tickets, et cetera,…in this case we can use a nonclustered columnstore index…to create a filtered index so our existing rows…are going into a b-tree table,…or maybe even an in-memory table,…so our inserts are very fast, but at the same time,…we can do analytics on our nonclustered columnstore.…
The scenario is not super common,…but you know it if you have it,…and occasionally you'll see a system…where performance will be poor…because a business is trying to report…off of their online transaction processing system…or sales type of system or manufacturing,…and not necessarily a data warehouse,…so they're trying to read off of a system…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.