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
Other News
DB2 data replication for z/OS: Performance evaluation and analysis
This document describes a set of DB2 Replication performance measurements collected on a single zSeries LPAR, non-data sharing z/OS system environment. (R,pdf)
Our Secrets to the My Namespace in VB 2005
(Keith Franklin) Although Visual Basic .NET is just as powerful as C# for building business applications, it did not get the initial push that C# did back at PDC 2000 when Microsoft unveiled .NET. This was not meant to slight Visual Basic and Visual Basic developers, but rather represented the s
Implementing XML Signatures in WSS4J
(Bilal Siddiqui) In this column, I’ll use the concepts discussed in the previous columns to implement XML signature support in our WSS4J API. As you know from previous columns, the WSS4J API implements the Token interface separately for different types of security tokens in WSS.
Checking to see if indexes exist
(Craig Mullins) I have a process that loads data through a nightly job. Say for example the job drops all the indexes and then loads the data and rebuilds the indexes. Is there an easy way to check if the indexes exist before even starting the dropping of the existing indexes. In some cases the proc
Sending e-mail from within Oracle
(James Koopmann) Using e-mail from within Oracle can be a great advantage. Many methods of sending e-mail extract the information and then package it up outside of Oracle. However, Oracle has supplied us with all that we need to do everything from within Oracle. This can be quite handy when we as DB
Oracle, open source putting the squeeze on SQL Server
(Robert Westervelt) Microsoft developers working on the next version of SQL Server are beginning to feel the squeeze from competitive pressures, as they race to release the next version of the DBMS. (R)
Achieving Programmer Productivity using a Reusable Framework and Code Generation
(Andrew Novick) This is good news. The promise of the .Net, programmer productivity, can be achieved. After my most recent project there is no doubt in my mind: .Net is the most productive environment for application development that I’ve ever used. The numbers are there to support this assertio
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
Using DMO to Enable and Disable Triggers
(Andy Warren) These code samples illustrate how to enable and disable all triggers in a database at one time – a task not easily done otherwise! If you haven’t use DMO before, I’ve posted two articles that you may find informative – Introduction to SQL-DMO and More DMO. (R)