March 2008 - Posts

0
Comments

Guideline for Resolving Deadlock by Kasim.Wirama

Guideline for Resolving Deadlock By : Kasim Wirama, MCDBA In shared database resource where concurrent access always occurs, you might see deadlock. If you want to get more information about deadlock in SQL Server 2005 such as latest SQL statement before...
Filed under:
0
Comments

Scalability Improvement with Temporary Table Caching in SQL Server 2005 by Kasim.Wirama

Scalability Improvement with Temporary Table Caching in SQL Server 2005 By : Kasim Wirama, MCDBA SQL Server 2005 has made interesting improvement on tempdb database. Probably, it will apply as well to SQL Server 2008. Pressure on tempdb database that...
Filed under:
0
Comments

Type of Deadlocks by Kasim.Wirama

Type of Deadlocks By : Kasim Wirama, MCDBA When concurrent accesses go to shared resource, there might be potentially deadlock issue. There are 2 conditions whether a deadlock might happen. First, deadlock needs at least two tasks or more and at least...
Filed under:
3
Comments

Tempdb Space Planning and Space Monitoring by Kasim.Wirama

Tempdb Space Planning and Space Monitoring By : Kasim Wirama, MCDBA Most of time, users don’t have to worry about running out space on tempdb as long as you have enough disk space to dealing with tempdb growth. Sometimes your tempdb has grown to considerably...
Filed under:
3
Comments

TempDB Improvement in SQL Server 2005 by Kasim.Wirama

TempDB Improvement in SQL Server 2005 By : Kasim Wirama, MCDBA In performance tuning area in SQL Server, there are five resources that are potential to contribute performance bottleneck. They are CPU, memory, I/O, tempdb and blocking. I will talk about...
Filed under:
0
Comments

Consideration to Choose between T-SQL and CLR-SQL by Kasim.Wirama

Consideration to Choose between T-SQL and CLR-SQL By : Kasim Wirama, MCDBA .NET integrates to SQL Server commenced from SQL Server 2005, and it will tighter in subsequent versions of SQL Server release (2008 and so on). I see that this architecture is...
Filed under:
4
Comments

Pro and Cons between Ad Hoc SQL and Stored Procedure by Kasim.Wirama

Pro and Cons between Ad Hoc SQL and Stored Procedure By : Kasim Wirama, MCDBA Before I give the pro and cons between Ad Hoc SQL and stored procedure, I would like to define what Ad Hoc SQL is. Ad Hoc SQL is SQL statements that is emitted from application...
Filed under:
0
Comments

Database Interoperability by Kasim.Wirama

Database Interoperability By : Kasim Wirama, MCDBA You need to consider your SQL syntax among database platform accessed from your application such as .NET, Java, etc. Interoperability in database is some of database issue that you need to consider and...
Filed under:
7
Comments

Implement Concurrency-Safe Stored Procedure for Update and Delete by Kasim.Wirama

Implement Concurrency-Safe Stored Procedure for Update and Delete In SQL Server 2005 By : Kasim Wirama, MCDBA Concurrency happens when two or more users access and modifies same resource. In this article, I would share would how you should develop UD...
Filed under:
4
Comments

MCDBA (Microsoft Certified Database Administrator) is Only Paper Certified? by Kasim.Wirama

MCDBA (Microsoft Certified Database Administrator) is Only Paper Certified? By : Kasim Wirama, MCDBA In offline discussion, some mailing list user asks what the proper salary is appropriate for a MCDBA. I think it depends on level that the use expects...
Filed under:
5
Comments

Status Pembuatan Buku Pemrograman Transact SQL by Kasim.Wirama

Status Pembuatan Buku Pemrograman Transact SQL (SQL 2000 dan SQL 2005) Sekitar kuartal keempat tahun lalu (2007), saya sempat mengundang rekan-rekan untuk berkontribusi di dalam pembuatan buku pemrograman Transact SQL. Sedianya saya targetkan selesai...
Filed under:
0
Comments

Dengan Piece Meal Online Restore di SQL Server 2008, Saatnya Mission Critical Industry Migrasi ke SQL Server 2008 by Kasim.Wirama

Dengan Piece Meal Online Restore di SQL Server 2008, Saatnya Mission Critical Industry Migrasi ke SQL Server 2008 by : Kasim Wirama, MCDBA Dalam rangka menaikkan tingkat penetrasi SQL Server ke mission critical application di dunia finance seperti core...
Filed under:
0
Comments

Spatial Data Type in SQL Server 2008 CTP by Kasim.Wirama

Spatial Data Type in SQL Server 2008 CTP By : Kasim Wirama, MCDBA One of bunch of enhancements made by SQL Server 2008 that is in CTP now is spatial data type. What can spatial data type do? It can save and display information about location of an object...
Filed under:
1
Comments

HierarchyId, New Data Type in SQL 2008 (CTP) by Kasim.Wirama

HierarchyId, New Data Type in SQL 2008 (CTP) By : Kasim Wirama, MCDBA One of enchancement made by SQL 2008 in CTP is hierarchy type data type. It is CLR based data type, so the method name is case sensitive. You can see some hierarchy examples such as...
Filed under:
3
Comments

Change Data Capture in SQL Server 2008 CTP by Kasim.Wirama

Change Data Capture in SQL Server 2008 CTP By : Kasim Wirama, MCDBA To record data changes in a table, we have to make another table and manually implement trigger on source table that capture data changes into change table. This is done in SQL Server...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems