{ "search-interviewsNoData_300x250_right": {"name": "search-interviewsNoData_300x250_right","id": "div-AdSlot-lfpy1tbi","width": "300","height": "250"} }
{ "name": "search-interviewsNoData_300x250_right", "id": "div-AdSlot-lfpy1tbi", "fluid": true }
{ "name": "search-interviewsNoData_728x90_bottom","id": "div-AdSlot-BL","width": "728","height": "90", "formFactors": "desktop,tablet" }
Senior sql database administrator sollicitatievragen
41
Sollicitatievragen voor Senior Sql Database Administrator gedeeld door sollicitantenMeest gestelde sollicitatievragen
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??
1 antwoorden↳
Without being able to restructure the existing schema your only choice is to de-normalize the data. When the data gets loaded on that weekly schedule, also build a flat table so there are no relationships being built. Minder
Er werd een Senior SQL Server Database Administrator gevraagd...27 augustus 2015
Cluster environment experience
1 antwoorden↳
I have good amount of experience in cluster setup and maintenance
Er werd een Senior SQL Server Database Administrator gevraagd...18 november 2017
What type of daily monitoring to your Database and describe it briefly
1 antwoorden↳
I explains my experience in Database level and briefly told them.
Er werd een Senior SQL Server Database Administrator gevraagd...24 november 2017
If you are having issues connection to your database server how would you troubleshoot
1 antwoorden↳
Firstly open sql server configuration manager an check if the sql server service is running, and if the protocols are enabled Minder
Er werd een Senior SQL Database Administrator gevraagd...26 december 2017
Er werd een Senior DBA-SQL Server gevraagd...22 juli 2020
Er werd een Senior SQL Database Administrator gevraagd...6 december 2016
