Answer Posted / c.jagadish

In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.

Indexes may be simple index or composite index.

Index formed based on single column values is called simple
index

index formed based on multiple column values is called
composite index.

Default index is NON CLUSTERED INDEX

When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.

Unique--- automatically creates a non clustered index

so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.

How to count rows with the count(*) function in ms sql server?

1007

---

What types of Joins are possible with Sql Server?

1116

---

Where the sql logs gets stored? : sql server database administration

960

---

What are the new features in sql server 2016?

965

---

What is log in sql server?

1141

---

What is report server project?

147

---

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

969

---

If a table does not have a unique index, can a cursor be opened on it?

911

---

Can you please explain the difference between primary keys and foreign keys?

1099

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1070

---

What is Service Broker in sql server 2012?

1016

---

What are sql server procedures?

967

---

Explain query editor regions

1037

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1941

---

Can you explain different types of joins?

928

---