Viewing 6 posts - 1 through 6 (of 6 total)
I have to disagree regarding the "natural" vs. "surrogate" primary keys. In almost all cases, surrogate keys are the better choice, for 4 reasons:
May 22, 2023 at 1:41 pm
You're right, it seems I missed the missing number 5.
May 10, 2021 at 12:38 pm
I think the correct answer should be 1, 10, 14.
May 10, 2021 at 7:42 am
Regarding the hassle with default and named instances: This distinction is a bit arbitrary. Also the "default" instance has a name, it is "MSSQLSERVER". This is the default when installing...
January 7, 2020 at 1:15 pm
I checked again with the INDEXPROPERTY function you mentioned. The 'IsPageLockDisallowed' property shows the expected values:
1 when ALLOW_PAGE_LOCKS = OFF
0 when ALLOW_PAGE_LOCKS = ON
I still get page...
February 17, 2017 at 7:56 am
February 17, 2017 at 6:44 am
Viewing 6 posts - 1 through 6 (of 6 total)