Unfortunately , I can't. Hence I tried to create similar using adventureworks.

The one posted in beginning.

Aslam.

Hi Chris,

Though the results are not matching . I like the logic.

I keep it open for a day for any other approach else I will mark as solution.

Aslam

Thanks .

Aslam.

Thanks Phil.

Still if there is any alternate logic . Its welcome.

Thanks

Aslam

Thanks Phil.

I was going through windows function and come across this query.

So just thinking if this can be done using them.

We have few queries in our environment similar to...

Thanks a lot .

It helped. 🙂

Surprisingly , The sql jobs started working automatically after few hours .

Still not able to find the cause.

If i was not having the error mails , i would would have...

No change . only ram increase.

Yes . It as has been set to automatic mode . Still I have tried restarting it. Does not help .

However just as a try , I recreated one of...

Thanks Gail. 🙂

If I have to restore this copy on other test /dev server , it will require that much space .

Sometimes the dev/test team asks for multiple copies . In this...

Hi Friends ,

Will you please help me on the next steps to recliam the space.As per me :-

a) Shrink the DB.

b) Rebuild the indexes.(This will again take some space thats...

Thanks.

Aslam

We have corrected the issue . However the solution was not very convinicing.

In one frequently called procedue , there was two levels of nesting . The developer reduced it to...

Hi All,

I have also observed the 4 instances(multi instance server) , sqlserver.exe using around 1.7 GB memory.

They are never crossing 2 GB.

As mentioned above we are using a 32 bit...