Join Martin Guidry for an in-depth discussion in this video Working with columnstore indexes, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, we're going to talk about…using the new column store index…in SQL Server 2012.…Before we add any new indexes to this table…let's go ahead and run a query…and see what type of performance we get…and then we'll run the same query…after we create the indexes to see the improvement…and performance.…So, I've staged some code for you for this…in your exercise files.…You'll wanna grab just the top part of that file…and copy and paste it into a new query window.…
Line 1 is going to drop the buffers…which we like to do when we're doing performance testing.…Make sure we're working with a clean machine.…Line 3 is going to SET STATISTICS ON,…specifically the IO statistics.…What I believe this index will do…is significantly reduce the amount of disc activity…for this particular query.…And so, I'd like to track that…so I'm going to look at the IO statistics.…And then line 5 and 6 is the actual query.…Fairly straightforward, fairly plausible query we would run.…
It's gonna tell us the sum and the average…of the UnitPrice and the OrderQuantity…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- 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.