1. How to find the tempdb contention? 2. What is the sparse file? 3. What is the redo file in log shipping? 4. What are the queues in sql server? 5. How to capture a trace from production without any impact on performance? 6. How to capture the long running...
1. What the issues you find in migrating databases 2. What is the schedule frequency of your transactional replication? 3. How do check the application compatibility with sql server? 4. How do you know whether statistics are latest or expired?...
1. Are tables locked during generating the snapshot? 2. Does Truncate Works in replication? What are the limitations of Truncate command? 3. Causes for slow replication? 4. How to add articles to existing publication without generating a full snapshot?...
1. Can we truncate a table which is participating in transactional replication? 2. How to identify log filling issue and can we issue shrink with truncate on publisher database? 3. How to filter the nested stored procedure or a command from profiler?...
1. Difference between 32 bit and 64 bit 2. How B-Tree formed for Clustered and non clustered indexes? 3. How B-Tree forms for indexes with included column? 4. Does alzebrizer tree stores in memory for stored procedures, views and constraints? 5. What...
1. What happens when a transaction runs on SQL server? Let’s say simple update statement “Update Table set col1 = value where col2 = value” Ans: It issues an update lock and upgrades it to Exclusive Lock The corresponding page would be captured from...
1. On which basis merge replication works on? 2. How to give a user to run a sql agent job? 3. Can we install SQL Server using a configure file? 4. What are the top performance counters to be monitor in Performance Monitor? 5. How do you know how...
1. How to rebuild a master database? Ho to restore a master database? 2. Any alternative to triggers? 3. What are the counters to monitor CPU usage? 4. Top 5 performance tuning tools 5. What events need to be added to capture execution plan in sql profiller?...
1. Why can’t we take a backup of a database which is in standby or in recovery mode? 2. How to move a database which is acting as a publisher in transactional replication? 3. What is CROSS APPLY? 4. How to find and remove duplicates from a table which...
1. An indexed view is referring only one base table. Both view and table are having index defined on them. Which index would be utilized when a query executed against the table. 2. I have an indexed view, now base table data has been modified, does the...
