Do you know the difference between a RANGE LEFT and a RANGE RIGHT partition function? Read on and discover a unique query to determine the actual partition a row is stored in. With this query you can quickly confirm your RANGE-assumption or find out where you got it wrong.
SQL Server organizes databases in chunks of 8192 bytes, called pages. Each page starts out with 96 byte of meta-information – the page header. Read on to see what kind of information is stored in this special area.