May 2011 Blog Posts
Saving space by storing decimal values in integer data types
Learn how to effectively store decimal values in SQL Server while taking up as little space as possible.
Avoiding page splits by… Splitting pages
Page splits are bad for performance, but don't base your clustered index on a sequential column blindly. Here's a situation where it doesn't make sense to do so.
Reverse engineering SQL Server page headers
Learn the internal format of a SQL Server page header as presented by DBCC PAGE. Using reverse engineering I'll show how to parse the header data.
Checking which database is stored in a detached mdf file
Learn how, using OrcaMDF we can figure out which database is stored in a deattached MDF file.
Bridging the gap between smallint and int
Learn the difference between smallint and int, as well as how to mimic the MySQL mediumint data type in SQL Server.
Wasted bytes add up, consider your data types carefully
You should consider your data types carefully when designing SQL Server tables. If not done properly you may waste lots of bytes per page.
Reading bits in OrcaMDF
Learn how bits are stored internally in SQL Server. In this post I'll also show how OrcaMDF parses bits from records.
Parsing dates in OrcaMDF
Learn how SQL Server data types like date, datetime and smalldatetime are stored internally. In this post I'll also show how OrcaMDF parses these types.
Implementing data types in OrcaMDF
Learn how OrcaMDF implements data type parsing as well as how to implement your own data type parser.
My PASS Summit 2011 abstracts
These are that session abstracts that I submitted to the SQL PASS Summit 2011.
Introducing OrcaMDF
Learn about OrcaMDF, the open source library for parsing SQL Server MDF files, by Mark S. Rasmussen.
|