Explain about Enhanced database mirroring in SQL server 2008
Explain about Enhanced database mirroring in SQL server 2008.
Expert
Data base mirroring in SQL Server 2008 is improved through:
Automatic Page Repair: This principal is enabled and mirror computers for recovering transparently by 823 and 824 errors in data pages, along with a request for a fresh copy of the page which is corrupted by the mirroring partner.
Improved Performance: This outgoing log stream is compressed through SQL Server 2008 for minimizing the network bandwidth which is required through database mirroring.
Enhanced Supportability: Added performance counters for enabling more granular accounting of the time that is spent across the various stages of DBMS log processing. Extensions of the existing views and Dynamic Management Views are comprised, for exposing additional information which is concerned to mirroring sessions.
Explain about the sparse columns of sql server 2008.
In MySql table how many TRIGGERS are allowed?
Describe the Hot Add CPU in sql server 2008.
Explain about Character Functions.
Explain about the extended events within sql server 2008.
What are the unique keys of database programming?
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
What are the requirements for Hot Add CPU?
Illustrates one event for Windows target of Extended Events?
18,76,764
1940548 Asked
3,689
Active Tutors
1428765
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!