The dreaded IS NULL OR construct is the root issue here. Fix it per Sean's link. Those simply MUST NOT BE ALLOWED ON YOUR SYSTEM - EVER! 🙂

I didn't even reads your post honestly. All I saw was the title. Never, EVER use maintenance plans in SQL Server for ANYTHING that is covered by the...

That's what Snippets are for silly! 😀 Actually for...

If you want the system diagnosed and fixed (if possible) ASAP, the ONLY way to do that with any reasonable chance for success is to hire a qualified performance tuning...

It truly is an elegant solution Chris! Kudos.

However, I will nit-pick on using sys.columns for the driver. 😎 That gets...

+100 to Lynn!!

Read my chapter in the SQL Server MVP Deep Dives 2 book entitled "Death by UDF" 😎

tl;dr

1) I think pre-aggregated data will always smoke real-time queries 🙂

2) since you are on SQL 2012, have a look at LAST_VALUE. It might be a better option than...

Step 1: Get a QUALIFIED PROFESSIONAL to help you and your company. To do...

hi2u (5/21/2013)

---

I was pretty sure that it's not possible, but i'm not an expert, so i needed a little confirmation first.

I think i'll go with the coincidence explanation. Thank you...

It can be done, but it is ugly cursor-driven stuff. CLR will likely be a good bit more efficient, but you will have a lot of code to write...

Anam Verma (5/21/2013)

---

I am involved in project of upgrading database servers to SQL 2012 using AlwaysOn functionality. It is still in planning phase and i am currently working on capacity...

Not only do you have the dreaded IS NULL OR construct, you also have a bunch of correlated SELECT..(SELECT..) calls too.

I have had success in examples such as this simply...

vamsi2.k (5/20/2013)

---

Hi SQLPhil,

I am facing a similar issue. I am configuring Merge Replication for a Database of Size 3GB.

When I run the SnapShot Agent My memory is falling down. I'm...

I recommend to my clients to never EVER use Maintenance Plans for ANYTHING. All standard/routine database maintenance activities should be done using Ola.Hallengren.com's FREE, FULLY DOCUMENTED, INCREDIBLY POWERFUL/FLEXIBLE scripts!!!...

There are quite a few different things you can "tune" a query to "optimize/minimize": duration, IO, CPU, Memory, locking, etc. In your case it would seem that you...