Viewing 15 posts - 8,011 through 8,025 (of 59,079 total)
What is the exact command that you're using to do the shrink?
How many files is TempDB made up of?
December 28, 2019 at 9:09 pm
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...
December 28, 2019 at 7:43 pm
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...
December 28, 2019 at 7:38 pm
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...
December 28, 2019 at 4:25 pm
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...
December 28, 2019 at 4:14 pm
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...
December 27, 2019 at 6:37 pm
(invoice_nbr CHAR(4) NOT NULL,
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...
December 27, 2019 at 6:13 pm
You're trying to fix it on the fly in your code and it doesn't really work that way in the real world.
Absolutely agreed but, unfortunately, the real world is...
December 27, 2019 at 6:05 pm
“Security through obscurity.”
Yep, that’s me. At the longest it’s been another 2”, but i live in Jackson, Wyoming and the beard can collect inconvenient amounts of ice sometimes.
I live...
December 27, 2019 at 5:59 pm
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...
December 27, 2019 at 5:56 pm
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...
December 27, 2019 at 4:32 pm
Do you also want the dates to be validated as "real" dates?
I'm asking this question because the translations you ask for are fairly trivial and I'm trying to generate...
December 27, 2019 at 4:23 pm
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...
December 27, 2019 at 4:18 pm
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...
December 27, 2019 at 4:02 pm
Viewing 15 posts - 8,011 through 8,025 (of 59,079 total)