Index tipping
Senior Sql Database Administrator Interview Questions
33 senior sql database administrator interview questions shared by candidates
How do you handle pressure situations?
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
Cluster environment experience
If you are having issues connection to your database server how would you troubleshoot
What type of daily monitoring to your Database and describe it briefly
What's the road map for next 10 years ?
Replication and name different types that you know
SQL Server Architecture, Big Data Architecture
Normal SQL Server questions
Viewing 1 - 10 interview questions