bulk import performance

SQL Server Error 5009: One or more files listed in the statement could not be found or could not be initialized

I had to add a log file to a database and then extend the size of this log file to…

Top Perfmon Counters to Identify SQL Server CPU Bottleneck

We should always monitor system resource utilization of our database servers and make sure that these utilizations should not exceed…

SQL Server Error 701: There is Insufficient System Memory to Run this Query

Today I am going to discuss SQL Server memory issues that your database Instance might face during bulk data load…

How to Improve SQL Server Bulk Data Import Performance?

I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are…