Browse by Tags

All Tags » Internals (RSS)
Page compression - internals and examples
First of all, apologies for the delay in writing this. I meant to blog about page compression as soon as I added it in to Internals Viewer but I didn’t get round to it. Going over it again for this blog post and testing things out with RC0 I found a few...
Posted 19 June 2008 08:57 PM by Danny | 2 comment(s)
Filed under: , ,
SQL Internals Viewer - New version with sparse column support
I've just released a new version of SQL Internals Viewer that has support for 2008 sparse columns, a feature introduced in SQL Server 2008 CTP6. There are also a few bug fixes and minor changes. It's available to download from http://www.sqlinternalsviewer...
Posted 02 May 2008 07:53 PM by Danny | with no comments
Filed under: , ,
SQL Internals Viewer 1.0 Released
I’m pleased to announce that SQL Internals Viewer 1.0 has been released. It can be downloaded from www.sqlinternalsviewer.com . I've also put up the first part of a user guide that covers the main window and Allocation Map. The second part will follow...
Posted 24 March 2008 12:21 PM by Danny | with no comments
Filed under: , ,
Row compression – internal structure
The CTP6 release of SQL Server 2008 includes row and page compression. It’s a feature that will only be in the Developer and Enterprise edition of SQL Server, so I wasn’t sure whether I should (or could!) add it in to SQL Internals Viewer . I had a look...
Posted 24 February 2008 07:31 PM by Danny | 2 comment(s)
Filed under: ,
SQL Server 2008 TIME data type
The new TIME type stores a time with a specified scale that defines the fractional second precision. The scale ranges from 0-7 representing 0-7 significant digits for the fractional seconds. The default precision is TIME(7), giving 7 significant digits...
Posted 10 January 2008 07:34 PM by Danny | 2 comment(s)
Filed under: , ,
SQL Server 2008 DATE data type
SQL Server 2008 has several new data types, including new date and time types. In a series of short posts I’ll go into how these data types are structured. All of these new types are supported in SQL Internals Viewer , and a new data type viewer is coming...
Posted 08 January 2008 06:57 PM by Danny | with no comments
Filed under: , ,