Types of SQL Keys We have following types of keys in SQL which are used to fetch records from tables and to make relationship among tables or views. Super Key Super key is a set of one or more than one keys that can be used to identify a record uniquely...

SQL Server Exception Handling by TRY…CATCH QL Server also has an exception model to handle exceptions and errors that occurs in T-SQL statements. To handle exception in Sql Server we have TRY..CATCH blocks. We put T-SQL statements in TRY block and to...

Difference between Checkpoint and LazyWriter C: Flush dirty pages to Disk L: Flush dirty pages to disk. C: Flush only Data pages to disk L: Check for available memory and removed Buffer pool (execution plan/compile plan/ Data pages /Memory objects) C:...

Error Handling Tips

DBA Daily Responsibilities On daily basis DBA should monitor the below Backups Confirm that backups have been made and successfully saved to a secure location Check the backup failure alerts, correct the errors and rerun the backups Review the average...

1. ​We have a log shipping environment. New data file has been added at primary server, what happens and how do you resolve it? 2. See we have a view which is getting data from different tables. One day it’s starts executing infinitely. I have seen no...

1. How many IP’s required configuring a 2 node cluster? 2. How many MSDTC required for a 2 node cluster? 3. What is the basic difference between 2005 and 2008 in clustering? 4. What’s the use of quorum in clustering? 5. Your customer complained that one...

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