Thank you , it works for me.

I found this one.

http://logicalread.solarwinds.com/best-practices-sql-server-virtualized-dc01/#.Vtch3U3ruig

Thanks all.

I cannot access the page,

https://sqlbits.com/Sessions/Event10/Deciding_if_Virtualization_is_a_good_choice_for_your_servers

Could you provide the link again.

Thanks

Thank you so much Hugo for your detailed advice, I learn a lot.

Thank you, good advice.

One more question, they also need to add a notification table, basically for each item too, such as notification for Hearing, notification for workshop, notification for invervention....

Thank you, a further question about the database.

For the new application data, it will be good and clean, if we create a hearing note, in the table of HearingNote,...

First, thanks every one for your patient and detailed answers. All your answers are very helpful. I really learn a lot from this.

We are not going to have many queries...

Thanks...

If a note belongs to a single object (either a hearing or a conference or a workshop or an intervention), then use:

Notes table: Noteid, NoteDetail, NoteDate, CreateDate, createdby, HearingID, ConferenceID,...

Also if I create a Notetable for each Object, what name should be called?

For example:

I have conference table,

Then I created a ConferenceNote table. It will be NoteID, notetype, ConferenceID,

In the...

so is it going to be something like this?

Note table: Noteid, NoteDetail, NoteDate, CreateDate, createdby

NoteBridgeTable:

columns: NoteID, NoteTypeID, Objectid (cannot find a good name for it)

Data:

Noteid, notetypid, hearingid

Noteid, notetypid, conferenceid,

Noteid,...

Thank you Hugo, Ed Wagner and Sergiy for your posts about using the entityid.

I kind of suspect at the very beginning the benefits of using entityID , esp, table...

Thanks all for the good tips.

Let me take a close look and may get back to you.

We originally did go the route that creates a note table, with NoteID and...

Because a record in the table may have one or more notes, that added in different dates. It may also have different noteType for the notes.

Thanks

Thank you, those are good tips.

I checked the data, the distinct ones are not few. So I may have to do some replace to make the time correct.

Thank you!