February 2008 - Posts

2
Comments

Indexing Tips for Optimal Database Performance by Kasim.Wirama

Indexing Tips for Optimal Database Performance By : Kasim Wirama, MCDBA I would like to give some tips how to do proper indexing that gives balance between SELECT query and DML (INSERT/UPDATE/DELETE) query. Here are the tips: If you have surrogate key...
Filed under:
0
Comments

Would You Like To Be a MVP? by Kasim.Wirama

Would You Like To Be a MVP? By : Kasim Wirama, MCDBA Most of you must hear about MVP. What is MVP? MVP stands for Most Valuable Professional , it is a form of recognition from Microsoft on individual who has excellent skill and passionate to sharing through...
Filed under:
0
Comments

Full Scan, Partial Scan, Index Seek in Performance Perspective by Kasim.Wirama

Full Scan, Partial Scan, Index Seek in Performance Perspective By : Kasim Wirama, MCDBA This article, I would like to share about scanning and seek in SQL Server. Those three terminologies from above title contribute significant database performance....
Filed under:
0
Comments

Implement Optimal I/O Subsystem for SQL Server by Kasim.Wirama

Implement Optimal I/O Subsystem for SQL Server By : Kasim Wirama, MCDBA Database performance is always considered as prone point of performance problem, one of I usually encounter is not optimal I/O subsystem. This article I would share points of planning...
Filed under:
2
Comments

SQL Server 2008 February 2008 CTP is released! by Kasim.Wirama

SQL Server 2008 February 2008 CTP is Released! SQL Server 2008 February 2008 CTP is ready to be downloaded, check this link http://blogs.msdn.com/euanga/archive/2008/02/19/sql-server-2008-feb-ctp-get-it-while-it-is-hot.aspx , follow the link to get the...
Filed under:
0
Comments

Trigger is Database Evil? Not Really.. by Kasim.Wirama

Trigger is Database Evil? Not Really.. by : Kasim Wirama, MCDBA Some people said that trigger should be avoided to whatsoever because it will slow down your database performance. Actually, I tell you that trigger has so many benefits, if you have good...
Filed under:
2
Comments

SPARSE data type in SQL Server 2008 by Kasim.Wirama

Sparse data type in SQL Server 2008 By : Kasim Wirama, MCDBA This article will introduce another new data type in SQL Server 2008, SPARSE type. In my sight, this sparse type is similar to numeric type with NULL. I am surprised that a conditional index...
Filed under:
5
Comments

Recover Damaged Database From Data File by Kasim.Wirama

Recover Damaged Database From Data File By : Kasim Wirama, MCDBA This article will show you how to recover database if your backup is not considered valid by SQL Server engine by saying that your database is not clearly shutdown. Typical action you need...
Filed under:
10
Comments

Assigning Sequence Number from SSIS by Kasim.Wirama

Assigning Sequence Number from SSIS (SQL Server Integration Service) By : Kasim Wirama, MCDBA This article will show you how to assign sequence number from SSIS when the destination table has integer column intended for sequencing, but not set it to identity...
Filed under:
0
Comments

FileStream Data in SQL Server 2008 by Kasim.Wirama

FileStream Data in SQL Server 2008 By : Kasim Wirama, MCDBA Upcoming SQL Server 2008 (Katmai) introduces Filestream data. With this filestream, you can save file, video or any other file that may have size exceeding 2 GB. Under the hood, they are not...
Filed under:
0
Comments

SQL Server 2008 Reporting Services New Feature by Kasim.Wirama

SQL Server 2008 Reporting Services New Feature By : Kasim Wirama, MCDBA Another area for enhancement in SQL Server 2008 is at reporting services. On November CTP, I try another new feature of matrix component called tablix feature. At glance, tablix display...
Filed under:
0
Comments

Declarative Management Framework in SQL Server 2008 (Katmai) by Kasim.Wirama

Declarative Management Framework in SQL Server 2008 (Katmai) By : Kasim Wirama, MCDBA SQL Server 2008 (Katmai) introduces DMF (Declarative Management Framework). It is framework to make your SQL Server database objects (from table until server level)...
Filed under:
0
Comments

Passing Table Value Parameter into SQL Server 2008 (Katmai) from .NET Application by Kasim.Wirama

Passing Table Value Parameter into SQL Server 2008 (Katmai) from .NET Application By : Kasim Wirama, MCDBA In last article, I show use of Table Value parameter in SQL Server 2008. This article will discuss how you use this functionality from .NET application...
Filed under:
0
Comments

Table Value Parameter in SQL Server 2008 by Kasim.Wirama

Table Value Parameter in Katmai (SQL Server 2008) By : Kasim Wirama, MCDBA Katmai (Code name for SQL Server 2008) introduces some new features in TSQL. One of them is Table Value parameter, it means that you can put table type parameter in stored procedure...
Filed under:
405
Comments

Database Structure Implementation Best Practice by Kasim.Wirama

Database Structure Implementation Best Practice By : Kasim Wirama, MCDBA This article, I would let you know best practices in implementing database structure from logical database modelling. It applies to SQL Server and probably to any other database...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems