With a clustered index, the data is at the leaf level of the index, so the index and the datapages are one in the same. The index is not a...

Thanks for all your help. Executing 'net name' in xp_cmdshell will also give the node name, but the cluster command gives more info.

This is a great idea, but I'm having trouble with it. I am doing:

create table ##cluster(

[Group] varchar(20),

Node varchar(15),

Status varchar(10)

)

insert into ##cluster

exec xp_cmdshell 'cluster /cluster:w2kclus1 group'

but I...

This lists the possible nodes (two in my case), but it does not tell me which one is hosting the virtual server at the time of the query.

Thanks!

It might be interesing to consider the technical difference between an acronym and an abbreviation. An acronym is one that one pronounces as a word, such as SCUBA. An abbreviation...

I don't think there's much difference between the two, because SQL Server actually creates a clustered index to enforce a clustered unique constraint. Create a clustered unique constraint, then query...