Hi David, Yes, the free one tells you how to work out what needs to be fixed, and how to use the system tools to do that.
The main course explains how it all works, and how to design them properly, and how to rationalise the ones that are there. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> |http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> On Behalf Of David Burstin Sent: Wednesday, 3 February 2021 10:23 AM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: [OT] SQL Server indexes Thanks for this Greg. I have enrolled for the free course and am trying to get my boss to pay for the SQL Indexing for Developers course. Really appreciate the free course to start with. Cheers David On Wed, 3 Feb 2021 at 09:00, Tom P <tompbi...@gmail.com<mailto:tompbi...@gmail.com>> wrote: Thanks Greg I will check out the course. Thanks Tom On Wed, 3 Feb 2021 at 08:56, Greg Low <g...@sqldownunder.com<mailto:g...@sqldownunder.com>> wrote: Hi Tom, If you’re doing development, you owe it to yourself to get good at indexing. There’s a bunch of content online. If you want something more detailed and to really understand it (which obviously I’d recommend), we have a good course on indexing here: https://training.sqldownunder.com. And you’ll also find a free course (4 Steps) there on working out what needs tuning, and how to do basic work. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> |http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> <ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf Of Tom P Sent: Wednesday, 3 February 2021 7:52 AM To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Subject: [OT] SQL Server indexes Hi folks I'm currently working with some stored procedures which were slow but are now super fast after I created some missing indexes the execution plan in SSMS told me to create. I'm not too familiar with SQL Server concepts but was hoping someone could point me in the right direction: are indexes something I can create and then forget about or do they need to be maintained long after I am gone from this project? Does a DBA need to be notified so they can look after them for example? I've read some things online but don't really understand most of it. Thanks Tom
