non-clustered-index

What are the differences between a clustered and a non-clustered index?

What are the differences between a clustered and a non-clustered index? ...

Selecting a Function Value Shows nvarchar(4000) on an Index

I have a view that I'm trying to setup an Index for. One of the select columns for the view executes a user-defined function that has a return value of varchar(250). However, when I try to setup an Index on that column, I see a size of nvarchar(4000). Why is that and will that cause a problem if I continue to setup my index? ...

converting clustered index into non-clustered index?

Is it possible to convert a clustered index to non clustered index or non clustered index to clustered index in sql server 2005. Please convert this query into clustered index: create index index1 on mytable(firstcolumn) Please convert this query into non clustered index: create clustered index clusindex1 on mytable(cluscolumn) ...