What are the different types of collation sensitivity in sql server?

1113

Can sql servers linked to other servers like oracle?

953

Which sql server is best?

992

When do you think a developer should use sql server-based cursors?

1047

Is the log file is a part of file group?

1038

Can we add an identity column to decimal datatype?

1002

what's the difference between delete table and truncate table commands? : Sql server database administration

981

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1107

Can we use pragma autonomous_transaction in trigger?

962

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

968

can a database be shrunk with users active? : Sql server administration

1007

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762

What is 3nf normalization form?

1111

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

991

Disadvantages of the indexes?

1125