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 >
