Kiran

You need to add a computed column to the table. Use the DATEDIFF function to set its value.

Incidentally, why are you storing date values as int in your table?

John

You can certainly run two jobs at the same time. Whether or not they have any impact on each other depends on what they do.

John

Add up the width of each column in the index, then add the width of the clustering key, and multiply the whole lot by the number of rows in the...

Steven

You're just doing the SELECT but not doing anything with the results. I think you can set up your job to divert the output to a text file or...

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