(Get new content delivered in your inbox: http://bit.ly/SSGRSS)
Please note that this a recorded webinar. It was recorded during live presentation.
In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes.
1. How to create them and some best practices to follow.
2. What is a covering index and how is it useful.
3. What is fragmentation and how to defrag indexes
4. What is fill factor and how is is useful.
Webinar resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources)
As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources.
Suggest us topics that you wish to learn through our webinars: http://www.dataplatformgeeks.com/dpg-suggest-topics/
Connect with DataPlatformGeeks: http://www.dataplatformgeeks.com/
LinkedIn Showcase Page: https://www.linkedin.com/showcase/dataplatformgeeks
Facebook Page (DPG): https://www.facebook.com/DataPlatformGeeks
Facebook Page (SSG): https://www.facebook.com/SQLServerGeeks
Telegram Community: http://t.me/edominerdatacommunity
Email us: admin@DataPlatformGeeks.com
Have technical questions? DataPlatformGeeks Community – Join the fastest growing community of data & analytics professionals
Why Join DPG? http://www.dataplatformgeeks.com/
-Attend all events hosted by DPG, including SQLMaestros Special Events
-Get access to free videos, labs, magazines and host of learning resources
-Download all events & conference material
-Learn new skills. Sharpen existing skills
-Be part of Asia’s Largest Data/Analytics Community
-Opportunity to be a regional mentor & speaker at our events
-Immense technical & professional development
Data Platform Summit 2019
Asia’s largest learning event on AI, Data & Advanced Analytics – Data Platform Summit 2019 was recently executed in Bengaluru at Radisson Blu (Outer Ring Road). DPS 2019 had 3 days of Pre-Con training on 19, 20 & 21 August 2019 and 3 days of the main Summit on 22, 23 & 24 August 2019. https://www.dps10.com/
A word from our knowledge Partners
SQLMaestros Video Courses
SQL Server Performance Tuning video course by Amit Bansal:
Amit Bansal’s Performance Tuning Video Course is part of a Master Series with more than 100 hours of content in form of professionally recorded HD videos and well-crafted outline with 20+ modules. It’s one of its kind in terms of breadth and depth of the content. It’s a master piece from the master.
T-SQL Querying & Programming Video Course by Satya Ramesh:
This video course is intended for Developers, DBAs, Data Professionals who work with SQL Server. In total more than 40 hours of content, which you can watch anytime, anywhere, and as many times as you want. http://bit.ly/satyavideocourse
Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere.
SQLMaestros Learning Kits
The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/
SQL Server Health Check
If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/
Connect with the founder of DataPlatformGeeks/SQLServerGeeks
Follow on Twitter: https://twitter.com/A_Bansal
Follow on FaceBook at http://www.facebook.com/amit.r.bansal
Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010
Facebook Page: https://www.facebook.com/AmitRSBansal