The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
959 views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
3
votes
1answer
137 views

Page Split Timing

So, imagine I have a page that I intend to cause to split. USE master ; GO IF DATABASEPROPERTYEX (N'Pages', N'Version') > 0 BEGIN ALTER DATABASE Pages SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ...
7
votes
1answer
450 views

B-tree node split strategy in SQL Server for monotonically increasing value

Consider a B-tree index on a value that will always increase monotonically, e.g. a column of type IDENTITY. With a conventional B-tree implementation, whenever a node is full, it will be split 50%/50% ...