yujinagata72 (8/16/2016)

---

Hi,

If I get a query plan XML, what kind of information will make it to be considered as a 'bad' plan?

I can think of the following:

- PhysicalOp="Clustered Index Scan"

-...

Just slapped this together, but you should be able to get this to work:

;with cte as (

select county, zipcode, count(*) as cnt

from table

group by county, zipcode)

select county, zipcode, cnt, row_number()...

Sorry, I am about to leave for an international trip and probably won't be able to assist effectively. Possible things to look into are:

1) Permissions. If this is development...

aminsoraya (8/14/2016)

---

Hi

I enabled service broaker and configured my MVC 5 app signalR properly . but when I run the project . and make changes to the table records . nothing...

Thanks for the pointer for the tool I wasn't aware of Steve. I like the ability to put your queries in different windows (with different connections even), and some other...

I quickly slapped this together. Can someone do some scalability testing for me to see how it stacks up with the other code? Sadly I have to grab a shower...

Brandie Tarvin (8/9/2016)

---

TheSQLGuru (8/3/2016)

---

Brandie Tarvin (8/3/2016)

I appreciate the suggestion, Eric. But my hands are tied on third party software. We're not allowed to use unapproved stuff. Hence hacking SSMS Object...

If you do this with a trigger, you MUST make it asynchronous!! I would either put the necessary information into a simple queue-style table or use SQL Server Service Broker....

Correct - TF2371 makes it MUCH more likely you will get stats updates at times when your application(s) don't need the additional burden on the server. 🙂

Note: I'm saying one...

lmarkum (8/5/2016)

---

Kevin and Jeff: Thank you both for the time you have spent on this thread.

I did find 165 indexes that had the NO_RECOMPUTE option on the...

Jeff Moden (8/5/2016)

While this doesn't qualify as the proverbial "monster join" table, it may well be worth your while to divvy it up using "Divide'n'Conquer" methods that store an interim...

That's GREAT, but it actually doesn't answer the question. 😎

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation...

lmarkum (8/5/2016)

---

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation because the...

1) You are at the mercy of how many rows are in the temp table referenced

2) CONVERT and CONVERT_IMPLICITs potentially affecting plan choice. Mismatched ad hocs, variables, column data types...