Can you provide the query?

Does the report need to gather real time data?

Or

Can you create a subscription and schedule for the report then also cache the results of that?

Is the developer using CLR by chance?

Also, do you have lock pages enabled?

u-haul

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity. The word it...

http://www.linkedin.com/in/craigawilkinson

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity. The word it wanted me to...

turbulence

Thanks Ron.

tune

Good and straight forward.

K - something still says that the query you posted is not the entire case statement as it is being run on your system.

WayneS (4/6/2012)

---

Jack Corbett (4/6/2012)

---

Okay a couple of semi-technical questions:

What do you all run to backup your home systems?

I may need to buy a new laptop soon. I...

run this query

select serverproperty('edition') as Edition

,serverproperty('productversion') as ProductVersion

,serverproperty('productlevel') as ProductLevel

Anurognathus