SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » tsql » SQL (RSS)

Browse by Tags

  • 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 was screaming because the IDENT_CURRENT was not working...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 11 2006
  • 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 with millions of rows in them in a live environment...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 25 2006
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems