web analytics

Tagged: SQL Server

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

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

Retrieve permissions on SQL Server database 0

Retrieve permissions on SQL Server database

Reading Time: 1 minuteSQL 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 0

How to Improve I/O performance for SQL Server

Reading Time: 2 minutes  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...

Import CSV file in SQL Server 0

Import CSV file in SQL Server

Reading Time: 1 minuteImporting 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...