Currently browsing

November 2012

Extended Properties

Extended Properties The documentations are an important part for every developer. In this article I am trying to discuss the self-documenting process of database by using extended properties. Before writing this article, I read several article for various sources related to extended properties to collect facts. Introduction Extended properties are …

LiangBarsky Line Clipping Algorithm with CC

Liang-Barsky Line Clipping Algorithm with C/C++ TheoryIn Liang-Barsky algorithm, we first write the point-clipping conditions in parametric form as  Each of these for inequalities can be expressed as , k = 1, 2, 3, …..where parameter p and q are defined as Any line that is parallel to one of …

PRIMARY KEY and INDEX

PRIMARY KEY and INDEX This article is related to PRIMARY KEY and INDEX. A common misconnects is that the PRIMARY KEY is always CUSTERED index.   Before going to the depth of this article I want to ask some common questions. My questions are mentioned bellow. 1.    Is PRIMARY KEY …

Key Lookup

Key Lookup This article is related to Key Lookup operators and how we eliminate them to improve the performance of our query. Introduction Key lookup operator is a bookmark lookup on a table where clustered index exists. It is quite expensive in terms of performance, so we have to eliminate …

3D Transformation Translation Rotation and Scaling in CC

3D Transformation [Translation, Rotation and Scaling] in C/C++ Translation In a three-dimensional homogeneous coordinates representation, a point is translated from position P = (x, y, z) to position P’ = (x’, y’, z’) with the following equations. x’ = x + tx y’ = y + ty z’ = z …

The general guidelines for Index

The general guidelines for Index We all know that the INDEX is a key factor of performance tuning. As proper index can increase the performance and bad implementation of index implementation can dramatically decreases the performance.  In this article I am trying to gather some facts from different sources, which …

Blocking in SQL Server

Blocking in SQL Server In this article I am trying to explain the Blocking. What is it Blocking in SQL Server is a scenario where one connection to SQL Server locks one or more records, and a second connection to SQL Server requires a conflicting lock type on the record …

Error handling

Error handling Error handling is a very important part of T-SQL development life cycle. Before SQL Server 2005 the error handling is quite difficult to maintain.From SQL Server 2005 Microsoft provide some easier process to handle our T-SQL error properly. In this article we are discussing about the Error handling …

Controlling Camera and Line of Sight in OpenGL

Controlling Camera and Line of Sight in OpenGL Camera controlling is essential in 3D viewing. OpenGL provides a function gluLookAt() for this purpose. The syntax of the function gluLookAt() is void gluLookAt ( GLdouble eyex,GLdouble eyey,GLdouble eyez,GLdouble centerx,GLdouble centery,GLdouble centerz,GLdouble upx,GLdouble upy,GLdouble upz ); .csharpcode, .csharpcode pre{ font-size: small; color: …

String To Integer and Integer to String Conversion in C

String To Integer and Integer to String Conversion in C In modern languages like Java, C# etc., there is a provision of function to handle String to Integer and Integer to String conversion. But in case of C, you should explicitly convert. String to Integer Conversion String is a array …

Data Types

Data Types As we all know the selection of proper data types is very important for a SQL Server Table objects. Without proper data types the performance is going down and it is un manageable for SQL developer. In this article I am trying to gather and provide a chart …