Blog

Indexed View (or) Materialized View

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.

By Admin

SQL Aggregate Functions

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. SQL Aggregate functions can be easily understood through examples. Here is a simple example table that will be used through out this article to demonstrate SQL Aggregate functions.

By Admin

SQL Trace (Transact-SQL)

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.

By Admin

Dot NET Collections

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

By Admin

Ranking Functions in SQL Server

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.

By Admin