Search


	Podcast:		voiceofthedba's podcast
	Episode:		Interviews: Covering Index
	Category:		Technology
	Duration:		00:03:13
	Publish Date:		2018-03-20 20:00:00
	Description:		Performance seems to be a part of every DBAs job. It should be a part of every developer's job, but I understand the focus to build software is different and many developers aren't sure how much a feature or option they work on will be used. They don't think too much about performance because at small scales, perhaps performance doesn't matter a lot these days with multiple cores and many GB of RAM. I'd disagree with that, but I understand the perspective. What's interesting to me is that in many interviews I've had over the years, I've not often been quizzed on specific scenarios that might help improve performance for queries. It seems many interviewers like to ask trivia questions such as the difference between a clustered and non-clustered index or what configuration knobs should I change. Code questions might be how to find duplicates in a table or deal with NULLs in aggregates. Read the rest of Interviews: Covering Index
	Total Play:		0