Explain primary key, foreign key and unique key?

987

Explain the rules for designing files and file groups in sql server?

982

How to retrieve error messages using odbc_errormsg()?

1045

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1043

how to create “alternate row colour”?

146

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1028

How to set the current database in ms sql server?

1073

What is the difference in accessing db between sql server vs sql azure?

174

What is master database? : SQL Server Architecture

1017

What do you mean by acid?

985

What are the advantages dts has over bcp?

997

What are data resources?

906

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2015

What is row_number () and partition by in sql server?

1078

Can we add a cpu to sql server?

1003