What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1263

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2522

Explain following error properties?

1017

What is a view in sql?

976

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1004

How to replace null values in expressions using isnull()?

1100

What are the advantages of the mirroring?

1094

How to execute multiple stored procedures at one time in sql server?

1011

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

Should you normalize audio?

941

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1026

What do mean by xml datatype?

1098

Tell me what do we need queues in sql service broker?

992

What are SSL and TSL protocols?

985

How to find index size for each index on table?

1003