Just to add to Hoo's post, if you need to shrink the footprint, you can run the dbcc shrinkfile command after you truncate the log, see BOL for details. Doing...

I assume you mean preserve the properties of the PK's and identity properties. One way would be to script them out and have it as a second task in the...

Also you can see locks using "sp_lock" or in EM.

Billy, query the heck out of books-online and you will learn a lot about locking. I was referring to a key lock, not a row lock, they are very similar...

Thanks, Interesting, can't immediately think of a pretty way to do this in SQL Server.

(admittedly Oracle ignorant) can you explain what a Key compressed index is?

I would limit the use of hints if at all possible. Keep in mind that indexes play a role in locking as well, I've seen heap tables prefer to do...

I agree with Frank, functionally you could use an instead of trigger off the view, but I personnally don't like that option.

Unless the nonclustered index is a covering index and SQL does not have to fetch back to the clustered table. This is why composite non-clustered indexes are so attractive.

This may help, he's written two articles on RS so far - http://www.databasejournal.com/features/mssql/article.php/3304481

NoelD, You're right, read it too fast.

DTS would probably be simplest.

one thing to add, if you will have multiple rows updated at once you will need to change this line:

WHERE TblName.Pk = I.PK

to WHERE TblName.Pk in (select PK from inserted)

HTH

A surrogate key (in contrast to a natural key) is an artificial key, it could simply be a column with the IDENTITY property.

HTH

IMO, your best friend in determing index placement is the "set statistics IO on" command. This will tell you the logical IO of your query which is the number of...