Scaling-Optimizing MySQL Database
August 18, 2011 by taxi · Leave a Comment
How to boost your MySQL database for high/Efficient performance? Following
Performance Tuning–SQL Server
January 23, 2011 by Nauman · Leave a Comment
Many 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
January 18, 2011 by Nauman · Leave a Comment
Finally 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. Developer and IT Productivity: new innovative productivity tools and features. Pervasive Insight: expanding the reach of BI to business users and [...]
Oracle database growth size
How 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
November 23, 2010 by Nauman · Leave a Comment
A 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
September 20, 2010 by Nauman · Leave a Comment
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
August 24, 2010 by Nauman · Leave a Comment
Today, 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. I started to look up Activity monitor, dbcc commands for any lock against the database, but of no avail. After searching [...]
Get indexes on all tables – SQL Server
August 24, 2010 by Nauman · Leave a Comment
An 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 be a lot of performance issues. While searching across internet, i came across a script that will list all the tables [...]
Migrate from MySQL to SQL Server
August 23, 2010 by Nauman · Leave a Comment
Migrate 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. More details can be found here
Remove a Stored Procedure in Production Environment
August 23, 2010 by Nauman · Leave a Comment
How 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 procedure is initiating before you can actually remove it from production. Following are some ways to determine the usage of a [...]