- [Instructor] You've learned about graph queries…and graph database in SQL Server 2017,…now let's going to move to a little bit more…of an advanced topic with graph.…In this scenario, we're turning graph queries,…so this process isn't going to be that dissimilar…from what we would do in a normal…SQL Server tuning environment.…We're going to look at things like execution plans,…we're going to look at the statistics,…and we're going to apply kind of our standard techniques…in terms of indexing.…In this scenario, we're going to work with a much…larger data set than you saw in the first…couple of examples where we just had a few records,…here we're going to have a million records.…
So graph queries have very similar execution plans…as regular tables.…You may need to, on larger data sets,…build custom indexes for the node and edge columns…that are auto-defined by SQL Server,…and index tuning may help with larger data sets.…In this demo, we're going to be looking at a data set…that's a million songs, so we used the million songs…
- Querying with SQL Graph
- String functions in SQL 2017
- Adaptive query processing
- Docker containers and SQL
- Deploying CLR code with SQL Server on Linux
- Working with SQL Operations Studio
- Using snippets
- Code deployment using GIT
Skill Level Intermediate
1. New Features Overview
2. Adaptive Query Processing
3. SQL Server on Linux
4. SQL Server Operations Studio
Using snippets3m 57s
Next steps1m 39s
- 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.