Grant Fritchey (7/30/2013)

---

A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but...

psingla (7/30/2013)

---

Paul,what exactly you mean by that..

As...

Moving data to another file (or deleting data) does not shrink the file.

You need to manually shrink the file to make it smaller, but this can lead to all sort...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1478917-2799-1.aspx

You can also create multiple unique indexes on the same table, but you can have only one primary key.

A unique index can also be filtered, while a PK cannot.

No problem, glad to help.

phamkhanhtung1989 (7/30/2013)

---

that is what I am asking for. to create the database, can I use the normal way as relational database? and which table do I have to create first,...

Probably implement the database? Create the tables, create indexes to speed up performance, if necessary create foreign keys.

OK, but now your grain of the fact table (meaning the lowest level at which you can analyze) is at the course level. Typically you would choose the lowest level...

Maybe you need to be a little more specific in your questions.

Need an Answer? Actually, No ... You Need a Question

That being said, there are several options to do this.

You...

First of all you have to think about what it is that you want to measure.

Is it the number of students enrolled in a course? The number of courses a...

How is the data transferred? Is a data flow involved?

SQLRNNR (7/29/2013)

---

L' Eomot Inversé (7/29/2013)

---

I think it's pretty...

Welcome. Any book by Itzik Ben-Gan will surely help you to understand T-SQL.

You can either insert it into a VARCHAR(MAX) column, or in a column with the XML data type.