2015
Oct
7
awarded  Popular Question
Jun
5
awarded  Scholar
Jun
5
accepted Tables shared information
Jun
5
comment Tables shared information
Ok, tks for your feedback
Jun
4
comment Tables shared information
All in all my sensation is maybe is better to simply add columns to each table.
Jun
4
comment Tables shared information
It's risky maybe. 2) Maybe yes but this is a constant column (default) 3) Maybe yes but this is just one column to join the external table
Jun
4
comment Tables shared information
1) This is not for tracking (creation+lastmodify is enough). 2) Maybe you are right, but I'll need to add the same columns on each table and this sounds like a duplication. 3) I would like to use for user authorization on records, so it would be used every time I query on a table. (If I used 10 tables on my query I'll need 10 joins on tracking table, this is the performance concerning about) OPTIONS 1) Managment studio in some situation recreate the table (i.e. add an identity to an existing primary key) so id could change, this is my doubt.
Jun
4
awarded  Editor
Jun
4
revised Tables shared information
formatting
Jun
4
asked Tables shared information
2013
Oct
22
awarded  Student
Feb
8
asked Migrate DB2 UDB (Iseries) to SQL Server