Excellent, thanks, I'll look into it! I'm not really familiar with service broker, but it sounds like a potential solution. To answer your question, I really do need...

Grant Fritchey (2/27/2013)

---

Estimated IO cost is only partly based on page count. But, the fact that you're getting discrepancies is the beginning of what might be the issue. Have you...

I compared the page counts for each index in the database between these two environments. The tables are identical in both, so the page counts are nearly identical as...

I've done some further digging on this, but I still haven't been able to determine why we're seeing this increased tempdb utilization. I pointed out in my original post...

Mr. Fritchey! Thank you sincerely for your reply. I'm honored -- your execution plan e-book has been my go-to reference on this stuff for years. 🙂

I updated...

Hugo Kornelis (9/28/2012)

---

However, the results returned may be completely different than what you expect, or want. For instance, when the optimizer chooses to use a parallel plan, it could just...

There's been a lot of discussion in this (oddly) revived thread today. I want to attempt to clarify something regarding a few comments in this thread, for my own...

Awesome article, Jeff, thanks! There are so many great takeaways here. Very interesting comments in the forum so far as well; I'm looking forward to following this one.

G...

Great ideas and tips, thanks. Has anyone found a solution for using extended properties to track ETL mappings? As in, these data elements in the source system feed...

Thanks for the comments! I like your simplified version, but be aware this code returns different results. Without the left joins, it will compare only the columns that...

I have also been thinking about the homework problem regarding the dating website. 😉 I don't think a solution is possible for the problem as presented.

Any given person...

jts_2003 (7/19/2010)

---

I also agree with the comment of making the TempDB files as large as possible - the last thing you want is a delay to a transaction because TempDB...

Tom Wilson (3/23/2010)

---

The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship between two other tables. ...

Hi all,

How do the results gleaned from this setup compare to what's available in the SQL2005 "missing index" dynamic management views?

Hi Will,

I think you may have missed my point as well. The purpose of a UDM (for example, according to http://msdn.microsoft.com/en-us/library/ms345143(SQL.90).aspx) is to provide a layer of abstraction when...