Eirikur Eiriksson (12/15/2014)

---

farrukhhameed786 (12/15/2014)

---

Hi

Please Below the query i need to use condition

I need to use in below query how to use

SELECT

ISNULL(EVT.VAL1/NULLIF((EVT.VAL2),0),0) AS ITEM_ID

FROM

EVENT1 EVT

WHERE NAME IN...

JeeTee (12/9/2014)

---

Where did you read nolock is deprecated?

Not that I'm encouraging use of nolock, but I see it's deprecated in from clauses in updates and inserts, but not straight selects....

Another thing to consider... in your four tables, if you only pull records that are time stamped within that last hour that you want to fetch and you dont need...

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