What is Deadlock? A deadlock occurs when users try to place exclusive locks on each other’s objects. Ex:- User1 places an exclusive lock on Table1 and then tries to place an exclusive lock on Table2. User2 already has an exclusive lock on table2, and...
The following Query will display the members in a group EXEC xp_logininfo '
What is TUF File in log shipping ? TUF file stands for Transaction Undo File inWhat is TUF File in log shipping ? TUF file stands for Transaction Undo File in SQL Server, .TUF file is the Transaction Undo File, which is created when performing log shipping...
Which trigger will be fire on Table Stament levelor rowlevel we can't say which vl fire 1st...Optimizer will taken care of that...answer is confusing but u hav to tell spontaneously
A clustered index determines the order in which the rows of a table are stored on disk. If a table has a clustered index, then the rows of that table will be stored on disk in the same exact order as the clustered index. An example will help clarify what...
How Do Bulk Binds Improve Performance? The assigning of values to PL/SQL variables in SQL statements is called binding. PL/SQL binding operations fall into three categories: in-bind When a PL/SQL variable or host variable is stored in the database by...
Using Dynamic SQL with Bulk SQL Bulk binding lets Oracle bind a variable in a SQL statement to a collection of values. The collection type can be any PL/SQL collection type (index-by table, nested table, or varray). The collection elements must have a...
Why Use Dynamic SQL? You need dynamic SQL in the following situations: You want to execute a SQL data definition statement (such as CREATE), a data control statement (such as GRANT), or a session control statement (such as ALTER SESSION). Unlike INSERT,...
What is meant by Active – Passive and Active – Active clustering setup? List out some of the requirements to setup a SQL Server failover cluster? How do you open a Cluster Administrator? What are the differences in Clustering in SQL Server 2005 and 2008...
Index Scan When SQL Server does a scan it loads the object which it wants to read from disk into memory, then reads through that object from top to bottom looking for the records that it needs. Index Seek When SQL Server does a seek it knows where in...
