Can you send us the plans of each queries??

SET SHOWPLAN_TEXT ON

GO

Select 'query here'

GO

SET SHOWPLAN_TEXT OFF

Another out of memory exception apparently!!!!!

Finish the original thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=220166

Maybe lightning strike might be a better choice of word compared to spark .

It's easier when you know what keywords to use. Good luck with that project .

Another out of memory exception apparently!!!!!

Finish the original thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=220166

Does that table have a text column?

Use the search feature on this site and enter the keywords Change Management for the article section. That'll give all the info you need.

Select name from dbo.SysObjects where XType = 'TR' and OBJECTPROPERTY(id, 'ExecIsDeleteTrigger') = 1 order by name

Don't be... happens more often than you think . Thanx for helping.

Can you manually rerun he job step by step to find which one failed? Maybe that'll give you a better error message to go on... or maybe there's some...

Did you specify a join condition in the view??

What's the authentication method to access that server?

How are you trying to access it?

Is the server started?

Something like this??

Select top 2 Dates from dbo.Calendar where Dates < @BusinessDate order by Dates Desc

Select col1, col2 from dbo.archive

union all

select col1, col2 from dbo.MainTable

I can add a little info on this but not much. As far as I know you can have perf degradation when you have lots of views being utilized...