The Windows Phone 8 Networking Survival Kit
Play Back to Indexes: The Original Culprit
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!
Download
Right click to 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
- High Quality WMV
Event Homepage
TechEd Europe 2013More episodes in this series
Microsoft SQL Server High Availability and Disaster Recovery on Windows Azure
Related episodes
Oracle to SQL migration - beyond SQL Server Migration Assistant (SSMA)
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