Author: SSWUG Research

Community

SQL Server Data Structure

The actual data in your table is stored in Pages, except BLOB data. If a column contain BLOB data then a 16 byte pointer is used to reference the BLOB page. The Page is the smallest unit of data storage in Microsoft SQL Server. A page contains the data in the rows. A row can only reside in one pag

Community

SQL 2005 Service Manager

(Jasper Smith) With the lack of an equivalent in SQL2005 for the SQL Server Service Manager that comes with SQL2000, I’ve decided to write one myself using C# and SMO. The download in this article is the first beta of SQL2005 Service Manager. There are a number of known issues with it currently

Community

SVG At the Movies

(Antoine Quint) If you’re a regular reader of this column, or if you just read the specification carefully, you would know that SVG is more than just a vector graphics XML vocabulary. While I won’t bore you here with the list of application contexts SVG is suited for, I will point out that since Day