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??
Explain what is Denormalization and why would you use that?
What RDBMS systems do you manage?
What is the difference between DELETE and TRUNCATE?
SQL server questions, write queries, know about health insurance process, ?
how you can improve the software so that every maintenance personnel can work in ease condition
there was a scenerio based question of which i have write a query. how to make changes of a table's coloumn based on certain condition of another table's column in a single query without using join.
Explain joins.
results of various sql queries
Error handling in ssis and sql.
Viewing 141 - 150 interview questions