Viewing 15 posts - 31 through 45 (of 6,831 total)
Be careful! The problems with a generic lookup table, structured like this:
( table_id smallint NOT NULL, data_code varchar(50) NOT NULL, description varchar(1000) NULL )
are:
(1) the data_code (key) must be made...
June 17, 2022 at 4:57 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 and (n...
June 17, 2022 at 2:06 pm
I use a start up procedure to send me an email whenever the SQL instance starts up. If someone failed it over, it will start up on another node. Of...
June 17, 2022 at 2:04 pm
A large table, even a very large table, should not necessarily be slow.
You need to review the clustering key(s) on those tables. The clustered index key selection is the single...
June 17, 2022 at 1:52 pm
Disk speeds on systems vary greatly. But you can always cancel the restore after (almost) 4 more hours. Cancelling a restore shouldn't take long at all, so you can wait...
June 16, 2022 at 6:46 pm
No. 236GB is not bad for a 2.4TB db. Once the log has been preformatted, you'll be back to the regular restore of the data.
The only way to make the...
June 16, 2022 at 5:31 pm
How large is the log file? SQL must restore the log file too, and, worse, it must preformat the entire log file before it restores to it. In essence, the...
June 16, 2022 at 5:09 pm
(1) If the query is fetching only columns that are part of the index, SQL will not need to access the main table at all and will just use the index. ...
June 15, 2022 at 2:51 pm
Excellent job! Looks much better than mine too!!
Some minor adjustments:
The PK for Ticket Response is ( Ticket Number, Ticket Response ID ) (in that order). Yes, a PK can have...
June 14, 2022 at 11:43 pm
If I modify the non key index [TransactionGuid] to include [TransactionId] as an included column on the non-clustered index.
No. Column TransactionId is automatically included in every nonclustered index (including the...
June 14, 2022 at 9:33 pm
More general notes:
(11) The attributes within an entity should apply only to that entity. For example, CPZ should be in the Ticket entity only if it CPZ relates directly to...
June 14, 2022 at 5:53 pm
Here's my initial cut at assigning Attributes to Entities. I tend to fully normalize, but you can back off of that later if you want to (in technical terms, we...
June 14, 2022 at 5:36 pm
OK, with that out of the way, what Entities do we have for this model? We must be able to assign each Attribute to an Entity. I'll make the Entity...
June 14, 2022 at 3:13 pm
Rules for normalization:
(1) Write names in normal language, no "camel case" naming, etc.
(2) Decide whether you want to use singular or plural names for Entities (there is lots of disagreement...
June 14, 2022 at 2:56 pm
Viewing 15 posts - 31 through 45 (of 6,831 total)