quote:

---

Why have a primary key on every table? Because Dr. Codd said so. I just have my developers read some...

Can you post the results of

DBCC SHOWFILESTATS

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Are you trying to reach Microsoft SQL or MySQL... wherever I heard earlier about PHP, the combination is MySQL/PHP and not SQL...

Our firewall is really picky. See for my job I need to do research on investments over the internet. Guess what happens when I try to open a link like

http://....technicalanalysis........

Another example I need clarification on.

Over here I tend to regard such job offers which advertise the compensation first of all as suspect.

Over there a different practice?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Don't worry about the connection speed. I don't know what we have, but DSL seems slow compared to.

Anyway, srgangu has a solution and that's good!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Ok, maybe you have a Link to Database Normalization rules I can read? I know I've read it before, but I...

this is going into theory. and there isn't an ultimate answer anyway. you should analyze your table structure and decide then.

remember, the definition of the 3NF is 'all non-keys are...

Don't seem so. Once again, only me....

Frank

http://www.insidesql.de

http://www.familienzirkus.de

hm...teaches me to post first and then talk

Frank

http://www.insidesql.de

http://www.familienzirkus.de

what about

DECLARE @x DECIMAL(5,2)

DECLARE @y INT



SET @x = 1

SET @x = @x / 8

SET @y = CEILING(@x * 5)

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

The article is ok. But before that i want to know the Full Explanation on Cluster Index and Ordinary Indexes with examples....

Did you reference Microsoft ActiveX DataObjects in your project?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Open EM. Click on a server registration and then choose Extras-> wizards.

Alterntively select a db, right-click->view->taskpad. And then choose wzard tab

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Try the link I've provided above or directly

http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de