You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1130

What is the difference between the 2 operating modes of database mirroring?

1164

What is database white box testing?

1177

What is ms sql server reporting services?

1125

What is difference between views and tables?

1077

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1072

what is the system function to get current user's user id? : Sql server database administration

1050

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

Can you name a few encryption mechanisms in sql server?

992

What are the limitations in ssrs on sql server express edition?

195

What is a trigger in sql server?

1229

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1727

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1446

Explain about thread and memory management process of SQL?

1016

How to replace given values with null using nullif()?

1040