I am still confused on the existence of the looping task. If you want to pull data hourly you can simply schedule the job to run hourly. Are you setting...

Is this what you are looking for ?

with MYcte as (

select studentUID, qual, max(regyear) as throughYear

from #AAA_Mytable

group by studentUID, qual

)

SELECTt1.termCalendarID, t1.regyear, t1.studentUid, t1.qual

,coalesce(oa.rollover, 0) as Rollover

from #AAA_Mytable as t1...

You probably have here the table being more index than data. The covering index helps but know the cost.... longer inserts, updates, deletes and makes maintenance plans (such as backups)...

When the process is ran by a job, is the job step using a credential to run? If so it could be an account different from the one the Agent...

From reading the posts on this topic, an idea is to use sort of a hybrid system . That is, I would explain the purpose of the report and anything...

Are you doing a lot of transformations to this data? SSIS is effiecient in its resource use when you have non blocking data movements. (IE.. no aggregating, sorting....). How is...

The Data Profile Viewer is installed through the SQL Server installation , not something that you can download for free (as of yet). In the install wizard one would uncheck...

I am wondering if it is possible that the sql server service on that host machine has eaten up most of the available ram, to where the other processes have...

You may even...

I'm assuming you are deleting/archiving based on the date here. I would try to build a clustered index on your table by date if it is not there already. Take...

Hmm, he may be interested in having the time portion to report what time of day he has the most business. In this case it would be ideal/wise to just...

You could schema bind a view to a table , so that the columns the view depends on are not altered until the binding is removed. This would have no...

Be aware to first sort by the actual date field , then your derived time field in the report. Else although your time filed will be ascending, the dates will...

Jeff Moden (11/24/2014)

Sean Lange (11/24/2014)

You read that document (which btw is more than 6 years old) and you...

revanappa.shivanagi (11/22/2014)

Thanks!!!. In my project column names of source and destination table are diffrent. So is ther any way to map individual column between source and...