Browse by Tags

All Tags » TSQL » SQL (RSS)

Is IDENT_CURRENT the next @@identity

I've just finished watching the webcast on building a wareshouse according to Kimball principles. In it they generate an audit record by inserting a record and then using IDENT_CURRENT to get the identity value. A few months ago some one on the forums...
Posted by simonsabin | 1 comment(s)
Filed under: , ,

Are you allowed to be sizeist in the database world

Well even if your not, one of my real bug bears is fat tables. These aren't large tables they are fat tables, wide ones with lots of columns or large data types. The reason this gets is is people develop databases with 10s of rows in them. Then end up...
Posted by simonsabin | with no comments