I am attending interviews for these days as a 5+ years of exp in SQL Server Dev. Most of the people are asking performance tuning level,about indexes, SQL profiler and some other advanced concepts. Frankly speaking i didnt get a choice to work in these concepts. moreover we dont have really such complex environment. but i have to change my job and i want to learn all these concepts.
Please guide me how to learn? are there any books or links i can refer.
Please help me in this. I really want to improve my skills as a senior developer. TIA.
Much of the material is geared towards administrators and architects, but that doesn't mean it's not beneficial to developers. There is a track for development in that list.
I also highly recommend the SQLSkills Immersion events. They may seem expensive but the return on investment is excellent. You basically get Paul and Kimberly (and Jonathan and Joe and Bob) for $75/hour for an entire week, AND THEY TEACH YOU how to fix problems yourself using their knowledge and techniques.
Another good starting point is SQL Servers Books Online. The 2008 version is good. There's a lot of information to get you started. After you've understood the concepts - get some hands-on experience, which could be as simple as setting up a SQL Server on a laptop and applying the techniques