Answer Posted / chandu

Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.

Non-clustered index:

Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2290

---

How to apply filtering criteria at group level with the having clause in ms sql server?

1044

---

What is subreport?

144

---

How you can move data or databases between servers and databases in sql server?

1099

---

How do you check sql server is up and running?

1045

---

Explain about merge replications?

1075

---

Explain nested join?

1030

---

How would you choose between a clustered and a non-clustered index?

1019

---

Why use update_statistics command in sql server?

1111

---

Can the query output be sorted by multiple columns in ms sql server?

1028

---

Is it possible to create trigger on views?

1029

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

---

How to concatenate two character strings together?

1166

---

How to download and install sql server 2005 books online?

1272

---

What are the different types of collation sensitivity?

1174

---