Currently browsing tag

Data

Columns Without Data Type

Columns Without Data Type Introduction  “Can you make a table with CREATE TABLE statement, where there are 4 columns and 1 of   the columns  is without data type?” If we heard this above statement, we definitely think for 2 to 3 seconds. That the columns without data type? The …

Data Entity Domain Referential Userdefined integrity

Data/ Entity/ Domain/ Referential/ User-defined integrity We all talk about the Data, Entity, Domain, Referential and User-defined integrity of the database. I think that we have a clear vision and idea related to those before implementing. I know that all the developer has the clear vision of that. This article …

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 …

Different Data Types in PHP

Different Data Types in PHP PHP supports wide range of Data Types. It supports eight different primitive data types: four scalar types (boolean, integer, float, string), two command types: (array and object) and finally two special types (resource, NULL). All these data types are discussed below: Boolean: Boolean is data …

TIME data type

TIME data type SQL Server 2008 introduced a new data type called TIME, which allow the TIME without DATE. Before SQL Server 2008 it is not possible. In this article I am going to explain the TIME data type by creating scenario to understand it better way. Scenario-1 [ The …

Database Compression Data Compression Part1

Database Compression – Data Compression Part-1 Database Compression – Data Compression Part-1 In this article I am trying to illustrate the feature of Data Compression in SQL Server 2008. Here I am trying to explain how the Data compression occurs. The real facts we faced that a database must grow. …

Data Structure Hashing and Hash Table Generation using CC

Data Structure – Hashing and Hash Table Generation using C/C++ Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string. Hash Function A function that transforms a key into a table index is called a hash function. If …

Integration with the XML Data Type

Integration with the XML Data Type With the introduction of the XML data type, we wanted to also give FOR XML the ability to generate an instance of XML directly (more precisely, it generates a single row, single column rowset where the cell contains the XML data type instance). Because of the backwards-compatibility considerations outlined …

How the Data Stores in SQL Server

How the Data Stores in SQL Server Data Page Data pages are the fundamental area to store data in SQL server. The data pages contains Pages header Data Row Row Offset or pointers. The maximum size of a data page is 8 KB Extents Extents are basic units in which …

Data Structure Implementing Tree Sort in C

Data Structure: Implementing Tree Sort in C++ In tree sort, the given data is first converted into a binary tree. The inorder traversal of the binary tree results in the sorted form which is known as tree sort. Algorithm 1. Declare and initialize necessary variables.2. Input the array of element …

Data Structure How to implement Shell Sort in C

Data Structure: How to implement Shell Sort in C++? Shell is generalization of insertion sort and is devised by Donald Shell in 1954. The method sorts separate sub-files of original file i.e. Divide the original file into smaller sub-files. Sort individual sub-files using any sorting algorithm We choose increment ‘k’ …