AFAIK you dan define logical relationships in ERwin in the logical model.

But I think that will be about the...

A PK is mainly for DA-purposes, to document the key that will be used to support FK-references to your table. ( http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/

)

Nowadays many rdbms systems only need a unique...

Indeed.

-If you can, migrate;

Reasons:

- in case of disaster you'll have to build your server exactly as your current server. i.e. start with install sql 7.0, restore your sql7.0 databases,...

If your DA / DBA do a good job documenting the relationships, they would for sure use DRI in the database itself AND document the external relationship in the comment...

- Defragging your table will help ! No doubt about it ! Less IO = better performance.

- less IO = less time needed to hold locks

- create an index that...

There is a little typo in the concatenations ( remove "as colname")

i've also added leading zeros to hours and minutes.

it should be :

Declare @theMinutes int

Set @theMinutes = 2945

Select convert(varchar(15),...

dw (4/25/2008)

---

Peso (4/25/2008)

---

To replace the functionality 100%, we should use LEFT JOIN.

The correlated subquery might return NULL if there is no match.

UPDATEmt

SETmt.FKID = x.FKID

FROMMyTable AS mt

LEFT JOINMyFK2Table AS x ON...

You may need to execute this more than once.

-- Shrink_TrxLog.SQL

--INF: How to Shrink the SQL Server 7.0 Transaction Log

-- SQL7 http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD

-- SQL7 http://www.support.microsoft.com/kb/256650

-- SQL2000 http://support.microsoft.com/kb/272318/en-us

-- SQL2005...

Did you try the set-based approach.

[Code]

-- avoid implicit rewrites by adding a nullable column

alter table Mytable add colmigrated datetime NULL; -- to keep track if data has already been processed

go

declare...

as Viking already stated, a column of datatype timestamp is of very little use outside of the sql db.

Even trying to represent it is useless.

btw a timestamp column is automaticaly...

keep in mind the number of rocket scientists is not that high 😉

Declare @theMinutes int

Set @theMinutes = 2945

Select @theMinutes / 1440 as NoDays -- 1440 minutes per...

- Check your sql7 service pac for the prereqs !

- Start with SQL2005 Upgrade advisor !

- run dbcc checkdb for all databases;

- if you can , don't upgrade, but migrate...

BIDS stands for BI-dev studio.

With sql2000 you need to be granted exec of the debug procs.

http://support.microsoft.com/default.aspx/kb/817178

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

prefer coalesce.

Not only because it is ansi, but also because it can do more for you.

isnull(thecol, thereplacement)

coalesce(thecol,thefirstreplacement, usethisifthefirstreplacementisNULL,...)

and I've had some issues with sql2000 when using isnull is certain...

With sql2005 the (sqlproc) debugging stuff has been shifted towards BI-dev studio.

This feature is NOT available if you only install the BIDS version MS ships with SQL2005.

Open BIDS

open the server...