Viewing 15 posts - 16 through 30 (of 6,831 total)
No, unfortunately you can't use WITH TRUNCATEONLY to free the space.
Fragmentation is possible from the SHRINK, so you'll have to check if any tables need rebuilt after you've shrunk the...
June 21, 2022 at 2:23 pm
That should reclaim space from that table back to the database itself.
I think you'll still need to run SHRINKFILE to free the space the database itself back to the disk.
June 21, 2022 at 2:13 pm
Does the system need to prevent duplicate responses to a Ticket? That would be complex to do at the very least.
June 20, 2022 at 10:03 pm
Remember, too, that the logical data model should be easily understood and use by business people. In fact, if possible, keep all developers out of the...
June 20, 2022 at 4:41 pm
You could just use the 1st for the day, which would mean it was still a valid date:
CONVERT(varchar(10), DATEADD(MONTH, DATEDIFF(MONTH, 0, Tab.date), 0), 120)
June 20, 2022 at 3:31 pm
This link gives a few reasons for choosing shorter varchar lengths.
In terms of storage, CHAR(n) columns are always n characters long.
VARCHAR(n) columns are anything between 2...
June 20, 2022 at 3:18 pm
Remember, too, that the logical data model should be easily understood and use by business people. In fact, if possible, keep all developers out of the first one...
June 20, 2022 at 3:14 pm
Thank you for your reply.
I took a look at your spreadsheet and immediately found a pretty nasty issue... about 2/3rds of the rows have duplicated Ticket Numbers.
Scott...
June 20, 2022 at 3:10 pm
Ticket response - can you have more than one response per ticket?
If Yes then its PK should be TicketResponseID and the Ticket Number should be a FK to Ticket
No,...
June 20, 2022 at 4:35 am
You can. That's the two choices for a code column: use a view to encode/decode and/or use a separate lookup table. A lookup table is technically a better design, but...
June 20, 2022 at 4:29 am
June 20, 2022 at 4:27 am
In the distribution db, query view dbo.syssubscriptions
June 17, 2022 at 9:57 pm
Hi Scott. Thanks for your reply. I understood most of what you said. I'd kindly like to ask for some clarification on some parts. But here is what I...
June 17, 2022 at 8:18 pm
In general I agree, although in a truly normalized design the number of tables can get truly overwhelming (like SAP!).
Certain simple things do not need tables. Instead, you can use...
June 17, 2022 at 6:48 pm
There are two main approaches:
(1) use a generic number for all codes, typically generated automatically by an identity column
So, type code = 1 might be 'Issue', = 2 might be...
June 17, 2022 at 6:17 pm
Viewing 15 posts - 16 through 30 (of 6,831 total)