Microsoft SQL Server Reporting Services is a comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, web-based reports from different types of data sources. This article covers the implementation details of generating an Ad hoc Report using SQL Reporting Services.
Continue reading about Ad hoc Reporting using SQL Server Reporting Services 2005
Here are some interesting shell commands that can be useful to any programmer working on UNIX environment
1. Viewing a zipped or Compressed file zcat <filename> This will help you to view the contents of a zipped file.
2. using the while command to keep the session [...]
Introduction
Databases are integral part of any application. There are applications which directly operate on databases. There are other applications that send requests to the aforementioned applications. The document provides the guidelines on how to go on with the testing of applications that directly operate on Databases.
The system test of these applications mainly concentrates [...]
Continue reading about Guidelines for Testing Database Level Application
This article provides SQL Server 2005 database DBA Checklist for database administrator.
The objective is to provide
Check list for database administrator
Overcome existing database server issues like CPU Utilization more (95%), growth in transaction log
Database Performance (CUP Utilization)
SQL Server 2005 database is 64 bit, its basic feature is it tries to use all the [...]
Continue reading about SQL Server 2005 database DBA Checklist for database administrator
General problem faced by most the database server is growth in transaction log file. This causes less free memory space on database server.
To recover from a situation where the transaction logs grow to an unacceptable limit, you must reduce the size of the transaction logs. To do this, you must truncate the inactive transactions [...]
Continue reading about (DBA TIPS) Maintenance Plan to avoid Transaction log file growth
DB2 Error: SQL1245N
Description : Connection limit has been reached. No more connections are allowed from this client.
Explanation:
The maximum number of concurrent database connections has been reached for an environment where the number of connections is restricted or must be predefined. The primary example of where this would occur is when the NETBIOS [...]
Continue reading about Error: SQL1245N Connection Limit Reached
DB2 Error: SQL1263N
Description : The archive file name is not a valid log file for database name on node node-number.
Explanation:
The specified archive log file exists in the database log directory or the overflow log directory on the specified node, but the file is not valid.
Roll-forward recovery processing stops.
Solution:
To determine the correct [...]
Continue reading about Error: SQL1263N Archive file name not valid
DB2 Error: SQL0161N
Description : The resulting row of the insert or update operation does not conform to the view definition.
Explanation:
The WITH CHECK OPTION clause was specified in the view definition that is the object of the insert or update operation or a FROM clause specified an insert or update operation with a [...]
DB2 Error: SQL0284N
Description : The table was not created because the table space tablespace-name following the clause clause is a tablespace-type table space.
Explanation:
The CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement specified a table space named tablespace-name following the clause clause that is not a valid type of table space for this [...]
Continue reading about Error: SQL0284N The table was not created
DB2 Error: SQL0290N
Description :Table space access is not allowed.
Explanation:
A process attempted to access a table space which is in an invalid state for which the intended access is not allowed.
If the table space is in a quiesced state, only processes which also hold the table space in a quiesced state are [...]
Continue reading about Error: SQL0290N Table space access is not allowed
