November 2009 - Posts

0
Comments

Returning SQL Resultset from Physical XML File by Kasim.Wirama

Returning SQL Resultset from Physical XML File By : Kasim Wirama, MCITP, MCDBA We live in XML format nowadays. Exchanging document is preferable in XML format generally. Now XML comes into database world and there is a requirement to read XML file and...
Filed under:
0
Comments

Shrink Database Causes Excessive Fragmentation by Kasim.Wirama

Shrink Database Causes Excessive Fragmentation By : Kasim Wirama, MCITP, MCDBA Shrinking database is used to release free space from unused portion of a database file to operating system. SQL Server provides option to turn on or turn off AutoShrink database...
Filed under:
1
Comments

Internal Fragmentation on SQL Server Transaction Log by Kasim.Wirama

Internal Fragmentation on SQL Server Transaction Log By : Kasim Wirama, MCITP, MCDBA Usually we hear database fragmentation on table level. And to remove fragmentation usually we do index rebuild or index reorganization. However, fragmentation could happen...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems