I would definitely stick to storing all data in a single unit.

You could use views to convert stuff. But then again, I believe that displaying a value in a certain...

Most efficient and best way is to use Update.

Maybe not only for performance, but just think about it when you are using referential integrity, identity values, ...

If you have the choice, I would not use Interdev. I do not like the interface.

If you're going to develop for IIS, you should be using Visual Studio.NET. ASP.NET is...

Embedded SQL should be, in general, a bit more performing in production, provided you've coded correctly.

Reason is that you leave out all overhead functionality you do not need.

However, as you...

Obviously, if you have a unique identifier somewhere in your table, you can do the 'joining' in the subquery on that field (or combination of fields).

Jonathan's solution won't work if the minimum values of both columns are not in the same row. It will return unrelated data.

A solution that will always work, regardless of the...

If this is really a timeout issue, check the documentation of the J2EE connection pool and mssqlserver4 objects.

I do not believe SQL Server closes any connection automatically, unless you set...

In EM, go to the Diagrams page and click 'Create New ...'.

Select all of the tables you want included and generate the diagram. You'll probably have to do some layouting.

One obvious question. Did you process the cube? Maybe try processing it once more.

The fact that you have defined it, and that the fact table is accessible, does not mean...

This has nothing to do with T-SQL.

By default, any SELECT statement returns a recordset that is 'read only'. Only if you are using a cursor, you can change the data.

It...

Don't know if anything is included with the Northwind sample. To add any kind of Blob in the database, you need to use the WRITETEXT or UPDATETEXT statements (see BOL...

At least you are distracted by the nice animations that they put into it.

And to think certain products even advertise that they have included an Assistant as an advantage!

Are the additions part of a transaction? If so, the transaction might have been rolled back for some reason.

I guess you are sure nothing strange happened to the server during...

I would go for a general 'property' table that stores all common data (like address, price, sq ft, ...). No problem if some of the fields are null (you probably...

Bear in mind that you need to run replication after your current host is off-line. Otherwise, additions or changes will not be done in the new database.

Does your system needs...