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> wrote: > Thanks Greg I will check out the course. > > Thanks > Tom > > On Wed, 3 Feb 2021 at 08:56, Greg Low <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 <ozdotnet-boun...@ozdotnet.com> *On >> Behalf Of *Tom P >> *Sent:* Wednesday, 3 February 2021 7:52 AM >> *To:* ozDotNet <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 >> >
