What is unique key constraint?

1119

What does it mean to normalize a database and why would you do it?

1026

Can we use trigger new in before insert?

971

What is a non-clustered index?

1049

What are entities and relationships?

1030

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

1002

What is difference between equi join and natural join?

1126

What do you understand by the data quality services in sql server?

985

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

What are the mathematical functions supported by sql server 2005?

1133

What are the advantages dts has over bcp?

1058

List out some of the requirements to set up a sql server failover cluster?

1083

Can we write a distributed query and get some data which is located on other server and oracle database?

1283

Does a sql server 2005 select statement require a from?

1077

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1123