I don't think it overwrites.

select case when 1=0 then 8 else sum(-10+1) end

from Master.dbo.spt_values

where 1=0

select case when 1=0 then 8 else abs(-10+1) end

from Master.dbo.spt_values

where 1=0

When aggregate it does not look...

VB was originally meant to be a hobbiest language and as such attracted a lot of people who simply did it as a hobby. Because of all of this a...

Really?

In VB it is a double-click....

Almost?

And what is a good programmer?

I think an object oriented programmer is a better programmer, regardless of language.

Even in COBOL.NET....

I find VB.NET better.

1. In a non-american keyboard it is easier to code faster since the curly brackets needs awkward keybard combination, AltGr + 7/0.

2. Case constructs is better:

...

Identity is evil.

Using identity as PK is bad.

Having a table like this:

CREATE TABLE Countries

(CountryID INT IDENTITY PRIMARY KEY,

CountryName VARCHAR(50) NOT NULL)

If I were Joe Celko I would...

The basic idea is to store all humans in one and only one place.

And all companies in one and only one place.

Thus Employees, Customers, etc gets stored in a Person...

You can't.

What you can do is a check constraint using a user defined function checking the existence of the "parent row" via a distributed query.

forgot:

Use the correct datatype: varchar(max), xml etx

In SQL 2008 there will probably be a datatype of type file.

/m

I would store the document in the database.

I would put the table in question on its own filgroup.

The disadvantages for storing only the link to the document in the filesystem:

I would scrap the generic table altogether.

Given a table called ShowReviews there would be a table called Shows.

In the table Shows I would have a column like ShowReviewId.

Which would be...

I think every table should contain facts from the reality that we keep data abot.

Review is not exact since it can be a Review of anything, a play, a car,...

Many thanks, now I "see the light".

/m

We have only outsorced the running of the servers including backups etc.

The productionDBA jobs, tuning etc, are still done by us.

So what do do besides "add logins to the sysadmin...

This works:

1. sql2005server  ---> sql2005server (windows domain account)

2. sql2005server ---> sql2000server on local machine  (windows domain account)

3. sql2005server  ---> sql2000server (local sql account on 2000server)

This doesnt work:

4. sql2005server  ---> sql2000server...