ORACLE AND MSSQLSERVER

1: What is an index? 2: What does a table look like without indexes? 3: What types of indexes are available in SQL Server? 4: What happens when you create a clustered index? 5: What about nonclustered indexes? 6: What about included columns? How can they...

SQL Server performance is affected by many factors. The most common SQL Server performance killers are poor database design, poor indexing, poor query design, not reusable execution plans, frequent query recompilation, excessive fragmentation, and more....

1.what is diffrence between 2014 vs 2016 ?2.How you configure SQl cluster?3.Do you know about ITIL Process?4.What is problem ticket?5.What kind of problems tickets you resloved?6.How to add a node in existing cluster?7.What kind of dmvs using for performance...

1. Explain WAL concept? 2.How to troubleshoot Service pack installation failed ? 3.Why every transaction log in t log file not data-file? 4.Diff between mirroring and log-shipping? 5. In log shipping copy job fail how to trouble shoot? 6.ACID properties?...

The MSDB database is the database with the backup and restore system tables. Here are the backup and restore system tables and their purpose: - backupfile - contains one row for each data file or log file backed up - backupmediafamily - contains one row...

SOLUTION The database backup and restore operation is an excellent method which is available to database administrators who need to upgrade a database from SQL Server 2000 or SQL Server 2005 to SQL Server 2008. Moving a database using backup and restore...

SQL Server Terminology Database – A database is an organized collection of data for one or more purposes, usually in digital form. Relational Database – A relational database stores data in separate tables instead of placing all data in one large table.....

Below is the query that tells the information about the SPID which has high Memory Usage in SQL Server. SELECT mg.granted_memory_kb, mg.session_id, t.text, qp.query_plan FROM sys.dm_exec_query_memory_grants AS mg CROSS APPLY sys.dm_exec_sql_text(mg.sql_handle)...

Types of Pages in SQL Server Pages are the basic storage unit of SQL Server. There are several pages available in SQL Server. Each page can store upto 8KB of data. Below are the various types of pages available in SQL Servers: Data Pages Data rows with...