December 2009 - Posts

0
Comments

Looking Inside SQL Server Data Row for Variable Length Column by Kasim.Wirama

Looking Inside SQL Server Data Row for Variable Length Column By : Kasim Wirama, MCITP, MCDBA I have shown information on hexadecimal value on fixed length column in my recent posting Looking Inside SQL Server Data Row . Now let’s have a look how variable...
Filed under:
0
Comments

Integrity Check Order in SQL Server by Kasim.Wirama

Integrity Check Order in SQL Server By : Kasim Wirama, MCITP, MCDBA SQL Server has 7 table constraints. They are DEFAULT constraint, NOT NULL constraint, CHECK constraint, FOREIGN KEY constraint, UNIQUE constraint, PRIMARY KEY constraint and trigger....
Filed under:
0
Comments

Question and Answer about SQL Server I/O Subsystem Issue by Kasim.Wirama

Question and Answer about SQL Server I/O Subsystem Issue By : Kasim Wirama, MCITP, MCDBA In SQL Server Indo mailing list, there was question about slow query performance on one SQL Server instance but not for the other SQL Server instance. This is something...
Filed under:
0
Comments

Determine Row Size in SQL Server by Kasim.Wirama

Determine Row Size in SQL Server By : Kasim Wirama, MCITP, MCDBA To be able to determine the number of rows for a page, you need to determine the row size for respective row. SQL Server could give you information through catalogue view. First let’s we...
Filed under:
1
Comments

Looking Inside SQL Server Data Row by Kasim.Wirama

Looking Inside SQL Server Data Row By : Kasim Wirama, MCITP, MCDBA If you have read my 2 previous postings ( Review SQL Server Data Page via Undocumented DBCC Command and Locate SQL Server Data in SQL Server Storage Engine ) about the use of DBCC PAGE...
Filed under:
0
Comments

Locate SQL Server Data in SQL Server Storage Engine by Kasim.Wirama

Locate SQL Server Data in SQL Server Storage Engine By : Kasim Wirama, MCITP, MCDBA If you are interested to know how SQL Server internal works, you will have options to optimize SQL Server. In this posting, I will show how to locate SQL Server data in...
Filed under:
1
Comments

Review SQL Server Data Page via Undocumented DBCC Command by Kasim.Wirama

Review SQL Server Data Page via Undocumented DBCC Command By : Kasim Wirama, MCITP, MCDBA Table in SQL Server is composed from one or more data and index page. You can examine where and how your data is located in physical disk and in-memory buffer by...
Filed under:
3
Comments

Behind Detach-Attach SQL Server Database by Kasim.Wirama

Behind Detach-Attach SQL Server Database By : Kasim Wirama, MCITP, MCDBA You probably have done copy database to other location by using either database backup or detach-attach database operation. Do you know what precisely happen behind detach database...
Filed under:
0
Comments

Tempdb Best Practice by Kasim.Wirama

Tempdb Best Practice By : Kasim Wirama, MCDBA, MCITP In area of SQL Server performance tuning, there are 4 possible bottleneck locations. They are memory, hard drive, processor, and tempdb. Tempdb should be taken care of because there is only one tempdb...
Filed under:
2
Comments

Objects in Tempdb by Kasim.Wirama

Objects in Tempdb By : Kasim Wirama, MCITP, MCDBA Tempdb role has more functionality in SQL Server 2005/2008 than previous versions. In SQL 2005/2008, tempdb has 3 types of object, they are : user object, internal objects and version store. What are they...
Filed under:
0
Comments

SQL Server 2005 - Query Rewriting for Performance Tuning by Kasim.Wirama

SQL Server 2005 - Query Rewriting for Performance Tuning By : Kasim Wirama, MCITP, MCDBA For many times, I am asked to solve slow running stored procedure. Interesting to know more? If yes, read on… I was asked by a user to work on a mission critical...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems