The program name column in sp_who2 may give you a clue. If not, and you are familiar with what the packages do, use DBCC INPUTBUFFER to get the command...

If you've got a lot of files in your folder, it will probably be more efficient to run a dir statement (or the equivalent in VB or Powershell or your...

Could be a problem with parallelism, especially given that it occurs on your high-spec servers but not on the lowly laptop. What sort of wait stats do you get...

Have a look at sys.dm_os_waiting_tasks while the application is running slow on your server. What is the most common wait_type for processes that are executing application threads?

John

IF USER_ID('test') IS NOT NULL

DROP USER test

Run against all databases. If you have so many that that would be tedious, use sp_ms_foreachdb.

For future reference, you can do all that...

Your function takes three parameters, yet in your query, you pass it four. Do you not get an error when you run the query?

We may not be able to...

You've got two options:

(1) Load the whole file into a staging table and do the processing in the database engine, using SSIS to do the final export back out to...

Gamit

What is the exact error message and what command are you using to restore the database? If you are using the GUI, there is a script button you can...

Table DDL, sample data and expected results would help us to help you. In the absence of that, what does this return?

SELECT DISTINCT rep_id, hcp_cid

FROM SE_Violation_Detection

John

Do you have any other tables that reference the identity column on this table? For example, are there any foreign key constraints?

John

Presumably your identity seed is 1? You could set it to -2,147,483,647. That would double your capacity - I don't know whether that would be enough?

John

Have you tried the dm_os_performance_counters DMV?

John

You're the database professional - it's OK,...

What are the differences between your login and the SQL Server Agent account login? Default database? Language? Anything else?

Does your package do anything user-sensitive, for example INSERT...

There's a limit to how small you can shrink a database. I can't remember off the top of my head what it its - I think it's either the...