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...

stuart.hemming (5/9/2013)

---

Hello,

I'm hoping someone can help me with a SQL query I'm trying to write; I'm relatively new to SQL so please bear with me if this is a numpty...

Here is an interesting solution that could be more efficient (didn't test that):

select

DT,

CAST(dt AS decimal(29,15))*86400 AS decdtsec2,

SecondsSince_19000101 =

-- seconds for whole days

(datediff(dd,0,a.DT)*000000000086400)+

-- seconds since start of day

datediff(ss,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)

from

(...