What is built-in/administrator?

566

Explain the properties of a relational table?

550

explain different types of joins? : Sql server database administration

520

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

613

What is Federation and Federation Member?

80

Who developed sql server?

520

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.

2023

What is “asynchronous” communication in sql server service broker?

533

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

474

Explain what you mean by 3 tier architecture.

619

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1502

How do you rebuild an identity column?

538

Explain foreign key in sql server?

566

Explain primary key and foreign key constraints?

518

What is compression - row-level and page-level compression?

520