Reading Time: 1 minuteHow to boost your MySQL database for high/Efficient performance? FollowingRead more
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 timRead more
Reading Time: 1 minuteFinally release date for SQL Server 2011 has been announced i.e November 11, 2010. The major features of the newRead more
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 scriRead more
Reading Time: 1 minuteA you are working on a busy database than you will often see this error.
It means that your session is trying to update an obRead more
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.
Reading Time: 1 minuteToday, I was taking a manual backup of a database through a scheduled Job. Normally this backup job takes aboutRead more
Reading Time: 1 minuteAn important ingredient in database designing is creating, maintaining and rebuilding indexes after some specified intervals. One main aspect ofRead more
Reading Time: 1 minuteMigrate from MySQL to SQL Server with ease. Microsoft has launched a small utility to migrate a database from MySQLRead more
Reading Time: 1 minuteHow to remove a Stored Procedure in SQL Server production environment? How can we be so sure that is notRead more