SQL Server Programmers Blog

Set Operators in SQL Server (UNION, UNION ALL, INTERSECT, EXCEPT)

expert@sql-programmers.com — Tue, 31 Aug 2010 15:57:00 GMT

SET operators are mainly used to combine the same type of data from two or more tables. Although more than one select statement will then be present, only one result set is returned.

More...

Extended Stored Procedures in SQL Server

expert@sql-programmers.com — Wed, 18 Aug 2010 05:31:00 GMT

“Undocumented Extended Stored Procedures” is a dynamic link library that runs directly in the address space of SQL Server. We can create our own extended stored procedures using the C Language. Query Analyzer will help you to run the Extended Stored Procedures. Here we are going to explain some useful extended undocumented stored procedures.

More...

Partial Class in C#

Tue, 10 Aug 2010 05:47:00 GMT

Visual Studio .NET 2005, ASP.NET 2.0, shipped with a lesser-known functionality called a “Partial Class”. A Partial class is a class defined in 2 or more files. Each source file contains a section of the class which will combine when the application is compiled.

More...

T-Sql Programmability Features in Sql server 2008 - Part 4

expert@sql-programmers.com — Wed, 04 Aug 2010 09:23:00 GMT

This is Part 4 of Tsql Features in Sql 2008. In this article we discussed about Table value parameters, Large user defined Types, Constructor support, The hieararcy id data type, DDL trigger enhancements and User defined Aggregate functions.

More...

XML Webservice in SQL Server

expert@sql-programmers.com — Mon, 02 Aug 2010 10:31:00 GMT

Microsoft provides a standard mechanism for accessing the database engine using SOAP via HTTP in SQL server 2005. Web services are Application Programming Interfaces, or web APIs, that will be accessed via the Hypertext Transfer Protocol and can be executed on a remote system. In order to run the following example, you have to install IIS.

More...

State Management in ASP.Net

Thu, 29 Jul 2010 11:16:00 GMT

State management is the process of maintaining state and web page information over multiple page requests.

More...

SQL Constraints

expert@sql-programmers.com — Mon, 26 Jul 2010 09:57:00 GMT

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).

More...

GARBAGE COLLECTION IN .NET

Thu, 22 Jul 2010 06:45:00 GMT

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.

More...

Nullable types in C#

Sat, 17 Jul 2010 05:39:00 GMT

Nullable types are the instance of the System.Nullable struct. A Nullable type can represent the normal range of values and a null value.

More...

Indexed View (or) Materialized View

expert@sql-programmers.com — Mon, 12 Jul 2010 08:48:00 GMT

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.

More...

SQL Aggregate Functions

expert@sql-programmers.com — Fri, 02 Jul 2010 08:42:00 GMT

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.

More...

SQL Trace (Transact-SQL)

expert@sql-programmers.com — Tue, 29 Jun 2010 09:17:00 GMT

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.

More...

Dot NET Collections

Wed, 23 Jun 2010 03:25:00 GMT

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

More...

Ranking Functions in SQL Server

expert@sql-programmers.com — Wed, 16 Jun 2010 04:15:00 GMT

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.

More...

SQL String Functions

expert@sql-programmers.com — Mon, 14 Jun 2010 15:23:00 GMT

SQL Server provides built-in functions to handle strings. Each function performs an operation on a string and returns a string or numeric value.

More...