Kalen has this post on this very topic on her blog. I have heard this question comeup evey now and then during presentation to why the 8k limit and what happens if we have beyond this limit etc? In SQL Server 2005 we can have overflowing rows that can span multiple pages. Check it out here from Kalen.
Archive for October, 2007
Overlapping Indexes in SQL Server 2005 October 22nd, 2007
Here is a post from the ISV team over the same. It is critical to see that we dont have duplicates indexes in the system. They slow the whole system down. Check the post here.
Excel 2007 Web Data Add-In October 20th, 2007
This is a work from the MSR team hence dont expect this to be supported from MS. Download the same here.
Report Builder – Totals Filter October 17th, 2007
Bob has this wonderful post on how to filter on totals with Reports Builder here. I know quite a few have asked me on this unique requirement. Thanks bob for this …
Transparent data encryption feature – SQL 2008 October 16th, 2007
Laurentiu points to this fabulous feature that is part of SQL Server 2008 and has some good explanation. Check the post here.