September 2007 - Posts

1
Comments

Bagaimana mengubah stored procedure yang berjalan 16 menit menjadi 1 detik? by Kasim.Wirama

Bagaimana mengubah stored procedure yang berjalan 16 menit menjadi 1 detik? By : Kasim Wirama, MCDBA, MVP SQL Server SQL Server 2005 memiliki banyak fitur TSQL yang memberikan lebih banyak pilihan dibandingkan dengan versi sebelumnya, karena SQL Server...
Filed under:
0
Comments

Importing Image into SQL Server with SSIS by Kasim.Wirama

Importing Image into SQL Server with SSIS Written by Kasim Wirama, MCDBA, MVP SQL Server This article will show you how to importing image into SQL Server with SSIS. Component relating to this job is Import Column component. It will extract file from...
Filed under:
8
Comments

Select Non Existent Record Without (NOT) Keyword for EXISTS/IN by Kasim.Wirama

Select Non Existent Record Without (NOT) Keyword for EXISTS/IN By Kasim Wirama, MCDBA, MVP SQL Server Usually, I am taught to display non existent record on one table by referencing some columns to the other tables with NOT EXISTS/NOT IN help. From performance...
Filed under:
1
Comments

How to get clustered index information with DMV in SQL Server 2005 by Kasim.Wirama

How to get clustered index information with DMV in SQL Server 2005 Written by : Kasim Wirama, MCDBA, MVP SQL Server I would like to share my code to query clustered index information for a table in SQL Server 2005 by leveraging dynamic management view...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems