All Questions
Tagged with database-internals sql-server-2008
7 questions
14
votes
2
answers
3k
views
In Search of FILESTREAM Insider Information
When the FILESTREAM feature is activated on Microsoft SQL Server 2012 then SQL Server will create a "hidden" share on the system. The share is defined as follows:
Sharename ...
- 18.9k
4
votes
1
answer
147
views
What happens at the data page level when the record length changes
I've been digging around the net at work when I can for a few days now trying to make sense of how a DBMS (SQL Server 2008 R2 and others) handles adding a column to the end of a huge table so quickly.
...
- 333
21
votes
2
answers
29k
views
What are the differences between leaf and non-leaf pages?
I've been running some index usage reports, and I'm trying to get a definition of Leaf and Non-leaf. There seem to be both Leaf and Non-leaf Inserts, Updates, Deletes, Page Merges, and Page ...
- 377
11
votes
1
answer
2k
views
NEWID() In Joined Virtual Table Causes Unintended Cross Apply Behavior
My actual work query was an inner join, but this simple example with cross join seems to nearly always reproduce the problem.
SELECT *
FROM (
SELECT 1 UNION ALL
SELECT 2
) AA ( A )
CROSS JOIN ...
- 364
42
votes
4
answers
24k
views
Does the order of columns in a table's definition matter?
When defining a table, it's helpful to order the columns in logical groups and the groups themselves by purpose. The logical ordering of columns in a table conveys meaning to the developer and is an ...
- 14.8k
4
votes
1
answer
1k
views
What is a parse tree object?
I have looked into sys.syscachedobjects table. I found some records have an object type of parsetree.
Can anyone tell me in detail what a parsetree is? Is this a data structure used by SQL Server, ...
- 141
13
votes
1
answer
2k
views
Slot Array and Total Page Size
I continue to read in many forums and on many blogs that a page is comprised as shown below:
Page Size: 16 x 512B = 8192B
Page Header: = 96B
Maximum In_Row Row: = 8060B
This leaves (...
- 1,437