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...

2. ...   Current trigger technology won't even directly allow the saving of LOB columns because the LOB values don't show up in the INSERTED/DELETED logical tables in standard...

Apparently, not. 😉

Good lord, NO!  That is so wrong in so many ways!  I suggest you read any good book on RDBMSs, especially if your going to...

Absolutely agreed but, unfortunately, the real world is...

I live...

ISO standards forbid embedded spaces in the encodings. There's also a set of Unicode characters that have to be used. It's the digits, Latin letters, and a limited set...

I also suspect that you want this to be conditional to check if there already is a "First Try" or not and add the extra row if there isn't.  I...

I'm asking this question because the translations you ask for are fairly trivial and I'm trying to generate...

If you're generating individual INSERT/VALUES statements, I wouldn't do that because it will take a month of Sundays to complete 1 million rows.  In fact, most methods will not to...

If order of execution is important for 1 procedure, it's likely inevitable that order of execution will be come a necessity for others, as well.  My recommendation is to build...