You're working in Azure. That's great. Just shift your brain a little and think differently about the solutions. The old style methods of having all the servers in a common...

sys.dm_exec_query_stats stores aggregate information about queries currently in cache. It won't show executions for any given moment in time. It's only ever aggregate information. It's not historical. Further, anything that...

TLDR Answer: Nope.

Long Answer: On SQL Cruise back in August, we had Bob Ward. Fantastic experience getting to hang out with the driving force behind a lot of...

I just got news of a new modeling tool. I haven't looked at it. If any of you feel like being a sacrificial anode, here's the link.

It was like...

Normalize the data structure, first. Use primary keys and enforced constraints through foreign keys. Next, put an index on the na_id column. Without it, you're scanning the entire table to...

Huge topic.

I polled a room of data professionals this week while speaking at a paid event, 56 people. All of them are using virtualization in one capacity or...

The execution plans are neither good or bad, they just are. They resolve as needed to make the query work.

Yes, the query, when correctly written of course, will...

I'm a little late to the discussion, so sorry if this is not useful.

It sounds little like you're trying to get something decent, but at no cost. Within...

This part of the query pattern is going to kill performance dead:
AND (ISNULL(A.ACCOUNT_NBR,''))

If nothing else, I'd find a way to restructure your data...