What is blocking and how would you troubleshoot it? : sql server database administration

1043

You want to implement the one-to-one relationship while designing tables. How would you do it?

965

How do you set a trace flag in sql server?

1035

Can we return Data from 4(more than 1) tables in stored procedure?

1059

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1162

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1033

What according to you is the difference between mysql and sql server performance?

1087

What is bcp? When does it use?

943

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

What is the difference between ddl and dml?

1047

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

1682

What is awe?

1012

Explain an automatic checkpoint

972

What do you mean by the term 'normalization'?

1209

What is a file group?

1090