Asa International india Microfinance DBA Consultant Interview Questions and Answers

Performing MSSQL database backup and restoration involves using SQL Server Management Studio or T-SQL commands.

• Use SQL Server Management Studio to perform backup and restoration tasks.

• For backup, right-click on the database, select Tasks, then Backup. Choose the backup type, destination, and options.

• For restoration, right-click on Databases, select Restore Database. Choose the source, destination, and options.

• Alternati...read more

Optimizing a slow-running query involves identifying bottlenecks and making adjustments to improve performance.

• Identify the root cause of the slow query by analyzing execution plans

• Consider creating or modifying indexes to improve data retrieval

• Optimize the query itself by rewriting it to be more efficient

• Update statistics on tables involved in the query to help the query optimizer make better decisions

• Consider partiti