Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
55 views

Merits of inserting to temp table and renaming versus just adding/removing columns

If I add or drop columns from a SQL Server table I presume I get page splits or gaps. Since the size of the row has changed. When I use RedGate SQL Compare to create conversion scripts its strategy ...
0
votes
1answer
24 views

SQL Server 2000 Page Splits per second higher han 12 million?

I was reading about index fill factors & performance, and out on a whim I tried the query given by the webpage on the company's production SQL Server 2000 server: SELECT * FROM ...
0
votes
2answers
72 views

Analyse what caused a pagesplit afterwards?

Ok normally we have 0-20 page splits per second, but last night it spiked to ~500. Now is there any way to figure out what caused it? I know i can run the following to find mid page splits but it ...
2
votes
1answer
63 views

Why only 8kb per page?

I just want to know how they came to 8kb when striking a balance between: smaller page = more page splits bigger page = longer to look through to find value I expect there are many more pros and cons ...
1
vote
2answers
3k 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
144 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
543 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% ...