of course this restored db also holds the sysjobschedules table ...

Maybe you can also use a DTS/SSIS solution to pull over new data every x time, unless your systems need is actually real time or near time.

Did you consider a...

Indeed, this would cause less system overhead ...

get-item c:\temp\ibn\IBN_1_56_4960135.sqlplan | foreach -process {if ( $_.length -gt 0 ) { send mail here }}

also keep in mind, scalar functions come with a performance hit for sqlserver !

So, while you're at it, because you'll have to modify all referencing queries (views, sprocs, other functions,...

another powershell addict 😀

Me, myself and Powershell[/url]

did you try to redo the first unsuccessful log restore ? (the one that failed during your outage)

( or a restart of it )

I haven't had this kind of issue...

You mean something like :

This one will fail if you got circular references !

;with cteObjHirarchy

as (

select 1 as MyLevel

, -1 as FK_object_id

, O.object_id as ChildObjectId

...

My bet - and this is...

Thank you for the feedback.

- Can you post related Windows eventlog messages ?

- can you find anything in the sqlserver errorlog file ?

Did you try indexing your table for the columns in your query ?

As you are talking performance, with your current design, this query (and almost all queries for that matter)...

I would implement windows security for that purpose whenever I can.

( both for your usage as sqladmin as well as for the other person to use in that monitoring tool/service...

if you are counting using e.g;

select count(*) from yourtable with (nolock)

Only in this case you'll get a good approx.

(because the number doesn't have to be exact)

Darned, I loved that series.

You've just made my day even better. #Goodtimes

The IT crowd - Truest moment about...

a while ago, someone wrote Changing Career Gears

It still holds truth

😀