By host on
7/29/2010 5:16 AM
State management is the process of maintaining state and web page information over multiple page requests.
Read More »
|
By host on
7/26/2010 3:57 AM
A constraint is a rule or condition defined on a table or table column(s) to prevent wrong data from being entered into the database. DML operations like INSERT, UPDATE or DELETE that violate the constraints are not allowed to modify the data and thus the constraints maintain the database integrity (i.e. the accuracy and reliability of the data in the database).
Read More »
|
By host on
7/22/2010 12:45 AM
The term “Garbage collection” can be defined as management of the allocation and release of memory in an application. Garbage collection is the mechanism to manage the memory by clearing up the memory allocated for unused objects in the application.
Read More »
|
By host on
7/16/2010 11:39 PM
Nullable types are the instance of the System.Nullable struct. A Nullable type can represent the normal range of values and a null value.
Read More »
|
By host on
7/12/2010 2:48 AM
Normally a view is just a SQL query which has only its definition but no data on its own until the view is executed. However, SQL Server allows us to create indexes on a view to significantly improve the performance of data retrieval operations.
Read More »
|
By host on
7/2/2010 2:42 AM
SQL Server provides many built-in functions that operate on a set of input values and result in a single output value. In this article, we are going to look at commonly used aggregate functions.
Read More »
|
By host on
6/29/2010 3:17 AM
SQL Trace provides a set of stored procedures to create traces on an instance of the SQL Server Database Engine. Through SQL Trace We can monitor events on SQL server without using SQL Profiler. Using SQL Trace we can find out who is using the database server, from which workstation or server, and which application is using it.
Read More »
|
By host on
6/22/2010 9:25 PM
Visual Basic .NET Collections are the data structures which hold the data in different ways for the operations. The important data structures in the collections are
- ArrayList
- HashTable
- Stack
- Queue
- Arrays
- Dynamic Arrays
Read More »
|
By host on
6/15/2010 10:15 PM
Microsoft introduced ranking functions in Sql Server 2005, which allows the sequential numbering of the result set. These functions are used in the SELECT query and are made to result in another new column. It displays the rank, an integer value for each row of the result set. There are four new ranking functions that have been added to SQL Server 2005.
Read More »
|
By host on
6/14/2010 9:23 AM
SQL Server provides built-in functions to handle strings. Each function performs an operation on a string and returns a string or numeric value.
Read More »
|
By host on
6/3/2010 3:04 PM
SQL mathematical functions are used to perform a mathematical operation and to return the result set of the operation. All math functions are deterministic except the RAND function.
Read More »
|
By host on
6/3/2010 12:56 AM
SQL Server provides many built-in functions and also lets you create user-defined functions. Configuration Functions are one of the built-in functions that help the user access information about the current configuration.
Read More »
|
By host on
6/2/2010 11:26 PM
The Bulk Insert can be used to insert data from a text file or a flat file into a SQL Server Table. When creating SQL Server 2000 ETL solutions, such as importing of text files, it is common for developers to employ DTS packages to achieve results quickly.
Read More »
|
By host on
5/22/2010 3:10 AM
This is Part 3 of Tsql features in Sql server 2008. this article explaines the merge and grouping sets features of tsql in Sql server 2008.
Read More »
|
By host on
5/22/2010 12:32 AM
This is the Part 2 of New Tsql Features of Sql server 2008. This article will explain the Date and Time features of tsql in sql server 2008.
Read More »
|