Q1)How to respond to a Full Transaction Log Error in SQL Server ?
Ans)
Normally the Transaction Log full Err occurred with 9002 Error code.
1. Backing up and Truncating the log.
2. Freeing the transaction physical disk space so that the log can automatically grow.
3. Moving the log file to a different disk drive with sufficient space.
4. Increasing the size of a log file(Initial and Growth).
5. Completing or killing a long-running transaction.
---------------------------------------------------
Q2)What is "Double Hop" in SQL Server ?
Ans)
One computer connects to another computer to connect to a third computer, is called a double hop.
---------------------------------------------------
Q3)What is Delegation in SQL Server ?
Ans)
SQL Server and Windows can be configured to enable a client connected to an instance of SQL Server to connect to another instance of SQL Server by forwarding the credentials of an authenticated Windows user. This arrangement is known as delegation.
---------------------------------------------------
Q4)Maximum How many Row(s) will be there in Sys.Indexes view for Each table in SQL Server 2008/2008 R2 ?
Ans)
Normally, When we create a new table, One entry will be there in Sys.Indexes view as 'HEAP' the Index_ID is '0', If we create a CLUSTERED Index on that table then, The 'HEAP' will be replaced as 'CLUSTERED' the Index_ID is '1'.
When we create a NONCLUSTERED Index on remaining columns then the Index_ID will be increased as 2,3,4,5....1005. Normally, a table can have maximum 999 NONCLUSTERED INDEXES and 1 CLUSTERED INDEX, Totally a table can have 1000 INDEXES.
But, The Index_ID in Sys.Indexes will be 0 or 1 to 250 and 256 to 1005 (Totally 1000 Indexes/Entries in Sys.Indexes View for a table). Then what about the 251 to 255 (5 Sequence have been reserved for Index Internals).
Finally, An Index_id will be 0 or 1 to 250 and 256 to 1005 (Maximum 1000 Entries will be there in Sys.Indexes View for each table), Minimum 1 entry will be there as 'HEAP' or 'CLUSTERED'
-----------------------------------------------
Q5) What is MERGE statement?
Ans)
MERGE is new feature in SQL Server 2008 that provide an efficient way to perform multiple operations. In previous version we had to write separate statement to INSERT,DELETE and UPDATE data based on certain conditions, but now using MERGE statement we can include the logic of such data modification in one statement that even checks when the data matched then just update it and when unmatched then insert it. most important advantage of MERGE statement is all the data is read and processed only once.
---------------------
Q6)What is BCP ?
Ans)
BCP is stand for Bulk copy Program in sql server, bulk copy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structure same as source to destination.
--------------------------------------
Ans)
Normally the Transaction Log full Err occurred with 9002 Error code.
1. Backing up and Truncating the log.
2. Freeing the transaction physical disk space so that the log can automatically grow.
3. Moving the log file to a different disk drive with sufficient space.
4. Increasing the size of a log file(Initial and Growth).
5. Completing or killing a long-running transaction.
---------------------------------------------------
Q2)What is "Double Hop" in SQL Server ?
Ans)
One computer connects to another computer to connect to a third computer, is called a double hop.
---------------------------------------------------
Q3)What is Delegation in SQL Server ?
Ans)
SQL Server and Windows can be configured to enable a client connected to an instance of SQL Server to connect to another instance of SQL Server by forwarding the credentials of an authenticated Windows user. This arrangement is known as delegation.
---------------------------------------------------
Q4)Maximum How many Row(s) will be there in Sys.Indexes view for Each table in SQL Server 2008/2008 R2 ?
Ans)
Normally, When we create a new table, One entry will be there in Sys.Indexes view as 'HEAP' the Index_ID is '0', If we create a CLUSTERED Index on that table then, The 'HEAP' will be replaced as 'CLUSTERED' the Index_ID is '1'.
When we create a NONCLUSTERED Index on remaining columns then the Index_ID will be increased as 2,3,4,5....1005. Normally, a table can have maximum 999 NONCLUSTERED INDEXES and 1 CLUSTERED INDEX, Totally a table can have 1000 INDEXES.
But, The Index_ID in Sys.Indexes will be 0 or 1 to 250 and 256 to 1005 (Totally 1000 Indexes/Entries in Sys.Indexes View for a table). Then what about the 251 to 255 (5 Sequence have been reserved for Index Internals).
Finally, An Index_id will be 0 or 1 to 250 and 256 to 1005 (Maximum 1000 Entries will be there in Sys.Indexes View for each table), Minimum 1 entry will be there as 'HEAP' or 'CLUSTERED'
-----------------------------------------------
Q5) What is MERGE statement?
Ans)
MERGE is new feature in SQL Server 2008 that provide an efficient way to perform multiple operations. In previous version we had to write separate statement to INSERT,DELETE and UPDATE data based on certain conditions, but now using MERGE statement we can include the logic of such data modification in one statement that even checks when the data matched then just update it and when unmatched then insert it. most important advantage of MERGE statement is all the data is read and processed only once.
---------------------
Q6)What is BCP ?
Ans)
BCP is stand for Bulk copy Program in sql server, bulk copy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structure same as source to destination.
--------------------------------------
About the Author
0 comments: