I've had to use "extension" tables here a few times too, for various reasons.

If you have an identity column present, do remember / be aware of the issues with...

Thanks Neil,

I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.

I will not be asking too many questions...

>> Why can I not create a new column and add 90 days to the date in column P_INDATE in MS SQL Server? <<

Why don't you put this computation...

Ah... and just noticed... you said your boss is using the import EXCEL wizard in your last post, which is different than your first post.  Which is it??? EXCEL or...

What you have posted in the image of your original post should do it.  I'm kind of confused, though.  You were right there or you wouldn't have been able to...

I'll be back.

If you're absolutely positive that 90 days will always be the magic number, you could make a computed column that would auto-magically populate the column for you?

How in SSMS is he importing the data?  BULK INSERT or something from the menu?

Oh no... not to worry.  I got "the jest" of it. 😀  That's why the smiley faces.

😀 😀 😀

Agreed. Unless the list of stored procedures was in flux and needed to...

What is the exact command that you're using to do the shrink?

How many files is TempDB made up of?

For those interested in what "Nominal Scale" actually is, there's a quick tutorial from 1:46 to 3:30 in the following video.  The two examples that they use to explain it...

I'm assuming that an invoice number uses a nominal scale. This is not a magnitude or quantity. That means it has to be a character string, but perhaps we could...

I suppose that if you don't want the LOB data in the temporal table, you could move all LOB data to an extension table with the same PK as...

For (1), you could add a column to the table itself to store the original login name there too (or, far better to save space, an id (that you...