Top posts

  • Oracle Core DBA Interview questions

    18 August 2015

    Oracle Core DBA Interview questions soon

  • Restore Strategy?

    18 August 2015

    Restore Strategy? 1. First restore recent last full backup 2. Then restore last Diff. backup 3. Then restore all Transaction Log backups since recent Full/Diff backups.

  • What is Backups? Types of backups?

    18 August 2015

    What is Backups? Types of backups? (i) “A copy of data that is used to restore and recover the data after a system failure”. There are four types of Backups available (1) Full Backup (2) Differential Backup (3) Transaction Log Backup (4) File /File Group...

  • What is Replication ?

    18 August 2015

    What is Replication ? Replication is the process of distributing data from one database to another on the same server or servers connected through LAN or the internet. Replication is used to synchronize data between databases that may be at remote lo...

  • Start SQL Server in different modes?

    17 August 2015

    Start SQL Server in different modes? Single User Mode (-m) : sqlcmd –m –d master –S PAXT3DEVSQL11 –c –U sa –P ******* DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P ******* Emergency: ALTER DATABASE test_db SET EMERGENCY

  • SQL SERVER -Resource db mdf and ldf file names?

    17 August 2015

    Q. Any idea what is the Resource db mdf and ldf file names? Ans: mssqlsystemresource.mdf and mssqlsystemresource.ldf

  • QL SERVER – Count Duplicate Records – Rows

    17 August 2015

    Duplicate Records SELECT YourColumn, COUNT(*) TotalCount FROM YourTable GROUP BY YourColumn HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC

  • SQL Server 2012 AlwaysOn Prerequisites

    25 August 2015

    Prerequisites 1. Windows Server Failover Cluster (WSFC). 2. Quorum configuration using file sharing (Optional). 3. SQL Server 2012 Enterprise Edition. 4. Collation settings have to same on both the Nodes. 5. Two to Five servers acting as a Replica.

  • Types of Materialized Views

    23 September 2015

    Types of Materialized Views 1) Read-Only : This type of MVs cannot send data back to the server Master tables. These server only one way communication i.e. from server to the client. 2) Updatable : This type of MVs can send the data, changed locally,...

  • Coming soon postgresql dba

    19 December 2019

<< < 10 20