Evil Kraig F (6/27/2014)

---

SQLRNNR (6/27/2014)

---

Evil Kraig F (6/27/2014)

---

Eirikur Eiriksson (6/27/2014)

---

The Dixie Flatline (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Koen Verbeeck (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Anyone think they can help this person? I think they really need...

Evil Kraig F (6/27/2014)

---

Eirikur Eiriksson (6/27/2014)

---

The Dixie Flatline (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Koen Verbeeck (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Anyone think they can help this person? I think they really need it, and what's more,...

Ok, I couldn't resist.

I took some liberties and modified the data. So here is the setup script

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Color]') AND type...

Here you go. Not gonna work through this one this time because it is similar to two blog posts I did already.

http://jasonbrimhall.info/2011/11/03/another-color-wheel/

You might start with this

http://sqlblog.com/blogs/stacia_misner/archive/2010/09/13/28742.aspx

It is sometimes easier to see those conversions when looking at the XML directly.

Open up the Plan XML and search for CONVERT_IMPLICIT.

There is also that warning on the select operator...

Then the next best thing for the time being is to start fixing data types and fixing those implicit conversions.

A quick glance shows that you are having some implicit conversion problems. There are also some cardinality estimate warnings.

And then there are multiple pieces coming in across a linked...

You can get my pricing by contacting us through the link I provided. Discussions on model, pricing, and scope can also be carried out there.

ado-712642 (6/27/2014)

---

I'd love to hire a DBA to go over this and figure out what we need to do. Even if it's making adjustments to our queries as...

You are welcome and thank you.

Must have money to burn.

Many of the recipes work on 2008. There is some functionality that did not change with the 2012 release.

And yes, if we cross paths I can autograph it.

Oh and FWIW - I am sure Grant will autograph the book. You see him doing that sort of thing at all sorts of events.

thomashohner (6/27/2014)

---

SQLRNNR (6/27/2014)

---

Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.

I would also recommend my book...