SQL Server 2005
SQL Server 2005 – Relational Database Engine
Database Engine is the primary component of SQL Server 2005, It is the Online Transaction Processing (OLTP) engine for SQL Server. It is responsible for the efficient storage, retrieval, and manipulation of relational and Extensible Markup Language (XML) formatted data. It is highly optimized for transaction processing
[...]
The following table compares the maximum sizes and numbers of various objects defined in SQL Server 7.0, SQL Server 2000 and SQL Server 2005 databases or referenced in Transact-SQL statements. The table does not include Microsoft SQL Server 2000 Windows CE Edition and Microsoft SQL Server 2005 Windows CE Edition. The table has the technical [...]
Continue reading about SQL Server – Maximum Capacity Specifications Comparison
Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it’s the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks [...]
Continue reading about Steps to Create and Deploy SSIS Package as a SQLAgent Job
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
Problem : A SQL Server cluster resource goes to a “failed” state when you try to bring the resource online in SQL Server 2005 or in SQL Server 2000
Resolution : Change the registry entry values HKEY_LOCAL_MACHINE\Cluster\Resources\
Continue reading about SQL Server Cluster Resource Failed When Bringing Online
Introduction
In a production environment, it is not always easy to determine why the sql job has failed and what has happened during the job step execution. The checklist provided here will help in arriving at a decision or give clear direction to troubleshoot
Checklist: First thing first, so let us go sequentially:
Check that the [...]
Continue reading about Troubleshooting SQL Server 2005 Jobs Failure
SQL Server 2005/2008 has a default Mail Engine in it, We can send email from SQL Server itself using the Database Mail. Database Mail is not active by default, in order to activate the Database Mail we need to follow Database Mail Configuration wizard or we need to execute sp_configure stored procedure with appropriate parameter.
Database [...]
Continue reading about Database Mail in SQL Server 2005/2008
This article explains the step by step troubleshooting methodology for correcting the error “The report server is not responding. Verify that the report server is running and can be accessed from this computer” that occurs in SQL Server Reporting Services (SSRS 2005). SQL Server 2005 Reporting Services (SSRS 2005) allows creation of reports which can be deployed to Report Server. Configuration is required for Report Server.This article provides a stepwise procedure to configure SSRS 2005 using SQL Server Configuration Manager.
Continue reading about Troubleshooting SSRS Error “The report server is not responding”
