Sorry, that link was the only one I remembered.

Well, I was talking about this normalization (taken from BOL):

Normalization

The logical design of the database, including the tables and the relationships...

See, if this helps:

http://support.microsoft.com/kb/q288095/

May I add, that I never have heard of a table with that much FK's. Ever thought of doing a bit of normalization on your schema?

Hm, can you show me how to get this running?

declare @open bit

set @open = 0

SELECT * FROM orders

WHERE

shippeddate

CASE @Open

    WHEN 0 THEN

          Is Null

     ELSE

         IS NOT NULL

    END

Server: Nachr.-Nr. 156,...

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Have you already searched the script section here? I bet you'll find a whole bunch of maintenance scripts there.

DECLARE @stmt nvarchar(4000)

DECLARE @rowcount bigint

DECLARE @table nvarchar(255)

SET @table = 'authors'

SELECT @stmt = 'SELECT @count = COUNT(*) FROM ' + @table

EXEC sp_executesql @stmt, N' @count bigint output', @rowcount OUTPUT

IF @rowcount >...

Yes, I think simple FLOAT instead of FLOAT(8) should work.

I could just fax them to you. 

Well, since on our side of the fax presumably still paper comes out, go ahead

Have a look at the explanations in BOL for FLOAT. If you create the table in EM you specify only FLOAT. With a default precision of 53 the column takes...

IT WAS A TECHNICIAN!

Sorry about that! In that case using punch-cards might be the better alternative

Sorry, after posting it I became aware that it might not be the best example to illustrate it. The basic idea is to assign the third highest or lowest value...

So far, I have looked at Dell and find them to be ok. Problem is call them. I could not understand the salesman. They all in India. When I ased...

Heja, nice to see you back here

What about EMC?

This is what BOL says about the CASE expression:

Arguments

input_expression

Is the expression evaluated when using the simple CASE format. input_expression is any valid Microsoft® SQL Server™ expression.

WHEN when_expression

Is...

Actually if you could provide DDL and the query you are more likely to receive good answers. Anything else is a shot in the dark.

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx

This one is for DB2. Maybe some ideas provided there will also help:

http://www.redbooks.ibm.com/redpieces/abstracts/sg247073.html