ORACLE AND MSSQLSERVER

Frequently Used Data Dictionary Queries 1.Index Table : Select INDEX_NAME ,INDEX_TYPE,TABLE_OWNER,TABLE_NAME,NUM_ROWS, LAST_ANALYZED,PARTITIONED From All_Indexes; 2. Index Columns : select INDEX_NAME,TABLE_OWNER,TABLE_NAME,COLUMN_NAME, COLUMN_POSITION,...

What is a Trigger A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. It is a database object which is bound to a table and is executed automatically....

Dynamic Management View Dynamic Management Views were introduced in SQL Server 2005. These Views give the administrator information of the database about the current state of the SQL Server machine. These values help the administrator to analyze problems...

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