The value data-type in this case will always be the same. I did not think using EAV, but several developers here thought that we should. Thank you everyone for your...

I understand and completely agree, but are there any other options? I dont see any but just add a column in the future when necessary.

Yes, like key-value pair.

Lynn Pettis (6/28/2012)

---

Biggest problem, we can't see what you see. Anything we tell you is nothing more than a shot in the dark. When you talk about a...

Gullimeel (6/28/2012)

---

For fucntion you can not get the plan as it is. You have to use the sys.dm_exec_query_stats dmv

and join this with dm_exec_query_text like below

select

dest.text,deqp.query_plan,deqs.*

from

sys.dm_exec_query_stats deqs

/*F0C6560A-9AD1-448B-9521-05258EF7E3FA*/ --use a...

Yes, the function does run during the day multiple times, but yesterday during the day it was running fast. So it had a clean and optimized plan. During the nightly...

Yes, we thought about that too, but in the morning if I run the job it is still very slow. The only time it is fast is if i free...

Hello, I would like to give users full job control, create, delete, change. How can I dio that. I want any user to change jobs not belonging to them and...

Hello, did you ever find a resolution for this issue?

thank you

Yes, I am sure the Work station does not have the server installed it only has Management Studio.

When I log on to the server itself and try to run it it is also pretty slow.

Could there be any Management Studio configuration that may cause this?

thanks,

Thank you for the replys and the links.

The server that is slow has about 0.76 GB and 5000 plans in the cache. I have another system 1ith over 120000 plans...

Thank you for the replies.

A few months ago I had an issue with the cache getting loaded by adhoc junk due to several badly designed systems.

I created a job...

Thanks, that worked.

What is the easiest way to compare between to plans created for the same object? Looking at them side by side they look the same.

Thanks,

Mishka

Thanks for your reply

Just to verify -

Would there be a benefit of having partitions where the partition range in a select statement is determined by a joined value to...