Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines. Responsible for database refresh and coordinating with QA Team. Proactive monitoring of SQL server known issues related to performance. Writing Custom scripts to refresh tables and monitoring jobs. Troubleshooting performance issues in production and non-production servers. Providing support for database mirroring, always on and log shipping implementation.
Technical question on DBMS management
First question: Tell me about page latching.
There was no difficult questions.
The most difficult question was about my weaknesses. However, I have learned how to handle that particular question. Other difficult questions were technical in nature. For example, questions about web servers and dot net applications.
How will you construct the database for 1000 users and what its size?
1) Types of joints in sql server 2) DML and DDL commands
Normal SQL Server questions
How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?
Tell about yourself and
Viewing 81 - 90 interview questions