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...

1. What is index reorganization? ​2. How sql engine knows which index has to be used while dealing with indexed views? 3. How to prevent bad parameter sniffing? What exactly it means? 4. What dll file that handle the transaction logs in logshipping? 5....

What database objects are stored in tempdb? Ans: There are three different types of objects stored in tempdb. Internal Objects: Intermediate runs for sort. Intermediate results for hash join and hash aggregates. XML variables or other large object (LOB)...

Performance Tuning – SQL Server Part – 1 Q. What are the bottlenecks that effects the performance of a Database / Application Ans: The top performance bottlenecks for OLTP applications are outlined as: Database Design \ Database Code Application Design...