The Windows Phone 8 Networking Survival Kit
Description
Yes, indexes still remain the main bottleneck when it comes to performance, especially when your data grows big. In this demo-heavy session, Amit takes you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus remains on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again!
For more information, check out this course on Microsoft Virtual Academy:
Day:
3Level:
300 - AdvancedSession Type:
BreakoutCode:
DBI-B327Room:
N104Share
Download
Download this episode
- MP3 (61.7 MB)
- Low Quality MP4 (358.7 MB)
- Mid Quality WMV (143.7 MB)
- Mid Quality MP4 (557.3 MB)
- High Quality MP4 (0.0 B)
- High Quality WMV (0.0 B)
For more information, check out this course on Microsoft Virtual Academy:
Event Homepage
TechEd Europe 2013More episodes in this series
Microsoft SQL Server High Availability and Disaster Recovery on Windows Azure
Related episodes
Baselining and Benchmarking AlwaysOn Availability Groups
Mind Your IO: Resource Governor Shows You How
Back to Indexes: The Original Culprit
The Discussion
-
AmitBansal Hi Audience, while my presentation & demos are ready, I still thought it wise to drop this note here, in case you are looking for something very specific on indexes. I can tune my demos if it does not deviate too much from my original script. Thanks and I look forward to see you at TEE13.
Regards
Amit
Personal Site – http://www.amitbansal.net/">http://www.amitbansal.netTwitter – http://www.twitter.com/A_BansalLinkedIn – http://www.linkedin.com/in/AmitBansal2010Forum & Blog – http://www.SQLServerGeeks.com -
martinjras @AmitBansal:hi amit! I saw the session live. You are a very skilled SQL guru, and a very skilled teacher as well. I much enjoyed the way you included us, the audience, in the talk.
Thank you very much.
-
AmitBansal @martinjras I am happy you enjoyed and it was worth your time !
-
Ashish Raghav Hi Amit, This is really a great session. I've learnt a lot from this session and really gonna implement these tips. Thanks a lot :).
-
Sajal Bagchi Hi Amit,
Both the session on indexes are really very helpful. Liked the way you demonstrate with relevant but simple queries. Thanks !!
Regards,
Sajal