Attach\Detach: 1. Take full database backup before performing activity. 2. After go to SQL Server database> tasks> detach> select drop all connections options 3. Copy files from one location to another location by using copy option but not cut method....
/3GB Switch: ___________________ By default SQL Server can be able to utilize 2 GB max meO\Smory in 32-bit o/s. If required to use SQL Server more than 2 GB then recomnded to enable /3GB swtch in BOOT.INI file. Note pad will be opened and at last enable...
Active Directory: Its a framework that holds the objects. The AD network can be addressed at different levels (Forest, Tree and Domain). Active Directory || Forest || Tree || Domains || Objects (Nodes/Computers) Forest: A forest is a collection of trees...
Examlpes For Complex Views Here are few examples of complex views in Oracle, a)Create Or Replace View Dept_Sum_Vu (Name,Minsal,Maxsal,Avgsal) As Select D.Dname,Min(E.Sal),Max(E.Sal),Avg(E.Sal) From Emp E,Dept D Where E.Deptno=D.Deptno Group By D.Dname...
Update and Delete in Correlated Sub query Correlated sub queries as you all know are used for row-by-row processing. Here each sub query is executed once for every row of the outer query. The oracle server performs a correlated subquery when the subquery...
SQL queries under workspace can suffer performance issues. Performance can affect due to huge SQL statements. Simpler SQL statements require less processing and generally perform better than complex statements. If you understand the purpose of statement...
The FORALL syntax allows us to bind the contents of a collection to a single DML statement, allowing the DML to be run for each row in the collection without requiring a context switch each time. CREATE TABLE forall_test ( id NUMBER(10), code VARCHAR2(10),...
SQL%BULK_ROWCOUNT The SQL%BULK_ROWCOUNT cursor attribute gives granular information about the rows affected by each iteration of the FORALL statement. Every row in the driving collection has a corresponding row in the SQL%BULK_ROWCOUNT cursor attribute....
The DBMS_XPLAN package is used to format the output of an explain plan. It was introduced in Oracle 9i as a replacement for the "utlxpls.sql" script or custom queries of the plan table. Subsequent database versions have increased the functionality of...
The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel
