create table Tags
(
  ID uniqueidentifier not null 
    constraint PK_Tag primary key clustered,
  [Name] nvarchar(100) null
) -- Tags

create table Articles
(
  ID uniqueidentifier not null 
    constraint PK_Article primary key clustered,
  Body nvarchar(max) null,
  Created datetime null,	
  Excerpt nvarchar(max) null,
  Published bit null,	
  Title nvarchar(400) null,
  Updated datetime null
) -- Articles

  create table ArticleTags
  (
    ArticleID uniqueidentifier not null,
    TagID uniqueidentifier not null,
    constraint PK_ArticleTags
      primary key clustered (ArticleID, TagID),
    constraint FK_ArticleTags_Articles
      foreign key(ArticleID)
      references Articles(ID)
      on delete cascade,
    constraint FK_ArticleTags_Tags
      foreign key(TagID)
      references Tags(ID)
      on delete cascade
   ) -- ArticleTags

quote:

---

Originally posted by tkizer

We can't really comment on what should be the clustered index on a table as that is based upon the data and your queries.

---