1) Give us a high level background of your experiences. 2) How would one resolve an SSRS report to render accurate data while it's underlying data is simultaneously being updated. 3) How do you optimize a SSRS report query that is slowly degrading in performance.
If Stored procedure is running slow
DR Plan strategy, If Ldf file is full
Most was typical questions regarding the technology I was going to use in the role.
What is Indexed View? Explain it with live example.
Database operations and SQL queries
Lots and Lots
What salary would you accept?
General aptitude test with quant,resigning etc which I attended in the start of my career
In addition to port 1433, what other port is open on a default MS SQL server instance (which can be used as a backup port in case of emergency)?
Viewing 3111 - 3120 interview questions