To identify "missing undexes" and unused indexes have a look at:

https://www.red-gate.com/library/performance-tuning-with-sql-server-dynamic-management-views

It will give you some tools and ideas for proactive index monitoring.

Excellent article Adam, 5 stars. I've enjoyed your each of your Power BI articles as it's something I've needed to become familiar with lately. Great work.

I learned this technique from Eirikur Eiriksson. One of those...

ChrisM@Work (6/1/2016)

---

Nice job Alan.

A few years ago DC and I played with numerous variations of this method as a spinoff of the PatternSplit project. One of the most promising methods...

mikes84 (6/1/2016)

---

I should have clarified. If it's part of a CTE, I can use a Tally table. I'm trying to avoid adding a physical table to the database as it's...

No more pre-coffee requests for me. I don't know why I didn't see it.:blush:

First, why no Tally Table? Have there been complaints that your queries are too fast perhaps?

OK, no other functions either, fine. Have a look at the article about APPLY referenced...

I don't know why you get an error. This code

CREATE TABLE Mytest (id INT, x XML)

INSERT mytest

VALUES

(1, CAST('1200' AS XML))

...

A couple thoughts...

First, I believe there are refresh property settings on tablixes, double check the settings on those.

Are you seeing this behavior in SSDT or when you deploy the...

Grant Fritchey (5/31/2016)

---

That's weird. It has to be a typo or a misinterpretation. They could mean normalization or optimization or... I've never heard of SQL Fertilization, so I've got nothing....

One way to approach this is to do it in the code.First back up your report. Then, in SSDT or BIDS (whichever you're using), you could select "View Code" then...

Attack

Jim Covington (5/27/2016)

---

In the IBM OS world, there is a view called a logical file. With a Logical file you can derive a subset of records and sort in...

TheSQLGuru (5/27/2016)

---

I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and the horrible...

Just finished this for the first time. Great work Gary! 5 stars.