SQL Server DBA face test

1.sqlserver 2008 R2 on Windows Server 2008 R2 cluster, nodes A, B, now need to stop. Add a new node C to replace existing node B, list the necessary steps.

2.sqlserver 2008 R2 on Windows Server 2008 R2 Cluster, Node A, b,a node memory is one-fold larger than B-node memory, the current master node, for business needs, the need to release a node memory that is, restart SQL Server, In the shortest possible time, how to let the Cluster service does not switch the operation does not switch to a node, list the steps.

3. The role of virtual log, how to see if the virtual log has an impact on performance? How to control the number of virtual logs to avoid

Too many virtual logs have a performance impact on the database?

4.sqlserver 2008 R2 on Windows Server 2008 R2, how do you avoid the logging of job production to errorlog during database backups to avoid errorlog being exploded?

5. How do I see the actual length of the text Type field in the table?

6. What is a database histogram? How do I design histogram statistics to provide database performance?

What is the understanding of 7.sqlserver partitioning table and its impact on performance?

8.sqlserver 2008 R2 on Windows Server 2008 R2 environment, the system log has been prompted to "Publish Key Management Services (KMS) to DNS failure in the XXXXX domain", causing the problem? How to resolve, please list the necessary commands?

9. How do I use char and varchar when designing a table? Please write down your understanding of varchar (max).

10.sqlserver 2008 R2 on Windows Server 2008 R2, improve backup speed as much as possible to save CPU?

11. A table has 120 fields, 85 million data, how to delete duplicate data?

12.ASP. NET invokes the SQL background stored procedure, the sometimes it gets very slow, it's okay to execute the stored procedure directly using the SQL statement, but it's slow when you call the stored procedure in the foreground, and it's the same slow call again after the foreground call succeeds, but update the stored procedure and call it quickly, please analyze why?

SQL Server 2008 R2 on Windows Server 2008 R2 environment, database error: "

18056

The client cannot reuse a session with a SPID of%d, which has been reset for connection pooling. The failure ID is%d.

This error may have been caused by a previous operation failure.

Check the error log to find the failure action that just occurred before this error message is displayed ", analyze the reason and the solution?"