I am just at the beginning of a new SQL-db and versus my bad habits earlier, where I didn't care for the right data-type, I would put my full focus first on my tables with the correct datatypes. I now have some fields where I store some balance-sheetnumerbs which are often in the high billions and therefore I chosen bigint but found out as I run Access2013 in frontend, latter can't handle this format. As no decimal is needid in these fields, shall I go for numeric instead as mentioned in the blog?
and secondly, I used to store some intermediate results out of queries in tables which I fill with data for more calculations and when the user closes the form, I delete the data in the table but not the table itself. Is this a reasonable way as I assume an empty table doesn't take a lot of space or do you recommend to DELETE/CREATE table each time and if yes, how to handle the possibly some users do the same query at the same time? I handled this by adding a username-field in the table, but if I go for CREATE/DELETE, it can happen that a user deletes the table?!