Performance Tuning–SQL Server

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

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 [...]

Cannot Resolve Collation Conflict

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

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

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

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

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 [...]

Retrieve permissions on SQL Server database

SQL Server permissions can be granted to on an object level (schema, database, database objects). In newer versions of SQL Server permissions can be given to user at a more granular level.

How to Improve I/O performance for SQL Server

  If underline I/O architecture system is working properly then every time SQL Server do some transaction (Read/Write) it can do it without waiting. But if load on the system is up, then SQL transaction have to wait for their turns for processing. This can significantly reduce SQL Server performance. There is a much greater [...]

Import CSV file in SQL Server

Importing a CSV(Comma Separated File) in SQL server is a very common task, and most of us use the Import /Export feature of SQL server to do this. Import/Export feature has SSIS (SQL Server Integration Services) as it backbone and works great with most of the Databases, file types etc. But today we are going [...]

Next Page »