Working as SQL Server Developer Cum DBA for over 5+ years in multiple projects I believe that everyone who works on SQL Server should have access & knowledge of Execution plans to assure optimised code design which uses appropriate indexing in background. But my experience says otherwise. Even for my initial two years of experience, we (developer) were not even having permissions to view execution plans or ever briefed about indexing & other performance concepts.
So please help me by answering below 8 questions in order to find the solution that could bride this gap and help the developers to earn the privilege. I will publish the results of this survey, along with conclusion once we have considerable vote counts.
[os-widget path=”/ajaydwivedi/birth-rights-of-sql-developer” of=”ajaydwivedi”]