I always use backup devices and withing a cycle (between full backups) have my log-bacups incremental.

Only very rare I've noticed backups failing because of the device.

We regulary test pit-restores and...

It is not mandatory to have a clustering index, but I'd advise to always have one.

did you try the "for each loop" container to get this doen (in stead of a script task)

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...