web analytics

Category: Databases

Performance Tuning–SQL Server 0

Performance Tuning–SQL Server

Reading Time: 1 minuteMany times in your organization an issue is raised that SQL server database is very much slow and its performance is not up to the mark. First thing that comes in mind is are indexes correctly applied to table that are being used? And most of the tim

SQL Server 2011 0

SQL Server 2011

Reading Time: 1 minuteFinally release date for SQL Server 2011 has been announced i.e November 11, 2010. The major features of the new products are as following: Enhanced Mission-Critical Platform: an enhanced highly available and scalable platform....

Oracle database growth size 1

Oracle database growth size

Reading Time: 1 minuteHow can we check the size of database growth? I needed to know this while generating a report for management regarding DB size.

Now here a little scri

ORA-00054: resource busy and acquire with NOWAIT specified 0

ORA-00054: resource busy and acquire with NOWAIT specified

Reading Time: 1 minuteA you are working on a busy database than you will often see this error.

Description

It means that your session is trying to update an ob

Cannot Resolve Collation Conflict 0

Cannot Resolve Collation Conflict

Reading Time: 1 minute
Collation can be defined at column level in MS SQL Server. An annoying error that comes up when using two columns that have different collations defined.

Percentage of Work completed – SQL Server 0

Percentage of Work completed – SQL Server

Reading Time: 1 minuteToday, I was taking a manual backup of a database through a scheduled Job. Normally this backup job takes about 1 hour to complete, but today it was still executing for almost 3 hours....

Get indexes on all tables – SQL Server 0

Get indexes on all tables – SQL Server

Reading Time: 1 minuteAn important ingredient in database designing is creating, maintaining and rebuilding indexes after some specified intervals. One mainĀ  aspect of database tuning is to apply indexes. Index must exist in databases otherwise their would...

Migrate from MySQL to SQL Server 0

Migrate from MySQL to SQL Server

Reading Time: 1 minuteMigrate from MySQL to SQL Server with ease. Microsoft has launched a small utility to migrate a database from MySQL to SQL Server. Name of the utility is SQL Server Migration Assistant for MySQL....

Remove a Stored Procedure in Production Environment 0

Remove a Stored Procedure in Production Environment

Reading Time: 1 minuteHow to remove a Stored Procedure in SQL Server production environment? How can we be so sure that is not being used any more? You need to know every single path from where this...