All Questions
Tagged with fill-factor data-pages
2 questions
2
votes
1
answer
272
views
Big Amount of <free_space_in_bytes> in Buffer Pool's Database Pages
We were viewing sys.dm_os_buffer_descriptors using below query
select
d.[name] [Database_Name],
(count(file_id) * 8) / 1024 [...
- 5,964
1
vote
1
answer
448
views
Will a composite Primary Key use the 15/16 page fill factor or the 1/2?
I understand that if a PK is a consecutive number, it will fill a page as its maximum which is a factor of 15/16. If it is a random PK the page fill factor will be of 1/2.
I was wondering if my PK ...
- 2,248