Nope. Just ran through all of it for an update to the book. It's as bad as it ever was.

I have a query that uses the execution plans in cache to identify potential missing indexes[/url]. Just remember though, these are just potential candidates. You should thoroughly evaluate the recommendations.

jcrawf02 (5/19/2014)

---

As for el Potter, what irked you so much Grant? Was it the fact they were lost in the woods (and whiny, oh so very whiny) for half the...

Jake Shelton (5/19/2014)

---

Again, let me get this straight...

Ie alter the table structure to change datatype so that these match between tables, or create the indexes that use datatypes that match...

If you used this:

Insert into table_name (j,k) values (Newid(),1123,456)

Then the default of NEWSEQUENTIALID wasn't actually used. Microsoft says that NEWSEQUENTIALID will be faster, so that's not a surprise. It's right...

If you read the documentation on NEWSEQUENTIALID, you'll see that it says that each GUID generated is greater than the previous GUID (until you get a reboot), but not that...

Yeah, seems reasonable. On my dev machine I just installed it right over the top of 2012 with no issues. Just so you know.

SQLRNNR (5/16/2014)

---

Grant Fritchey (5/16/2014)

---

To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix the conversion so that the...

17 indexes is not a small amount. That alone will negatively impact inserts and updates. So you should make sure you need all those indexes.

To address the scan, you need...

A CTE mostly just addresses formatting in this case. It's not going to change performance. You still have to address the things that I brought up or you'll just see...

Yes, you look at the foreign key relationships.

Ed Wagner (5/15/2014)

---

You know, I think that was a...

Oh, sounds like what we used to call the Logical Modeling Team. And **** NO they weren't in charge of us! When I started at the company, the DBAs did...

In general, if you have the name Architect in your role, I would assume you're, at least potentially, a step up over the DBA. I filled that role (didn't have...

You've got a bunch of stuff that's going to lead to scans. Adding columns like this:

(prev_stat.BIZ_YEAR + prev_stat.BIZ_MONTH)

For a comparison will prevent statistics use and lead to scans. Functions on...