What is application role in sql server database security? : sql server security

1119

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

999

What is inline variable assignment?

1082

What is spid in sql server profiler?

1168

Tell me what is normalization? Explain different forms of normalization?

1075

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?

1095

State the difference between local and global temporary tables?

1166

What is a file group?

1164

How to generate create table script on an existing table in ms sql server?

1193

Is candidate a key?

1002

how you can get the list of largest tables in a database? : Sql server administration

1100

Mention the different authentication modes in sql server.

1105

What is difference between clustered index and non clustered index?

1122

How to convert a table data in XML format in sql server?

2594

What are the properties of primary key?

1014