Viewing 15 posts - 2,716 through 2,730 (of 19,560 total)
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)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 4:49 pm
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)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 4:35 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 2:29 pm
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/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 12:41 pm
You might start with this
http://sqlblog.com/blogs/stacia_misner/archive/2010/09/13/28742.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 12:33 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 12:14 pm
Then the next best thing for the time being is to start fixing data types and fixing those implicit conversions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 12:07 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 11:59 am
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 10:15 am
ado-712642 (6/27/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:49 am
You are welcome and thank you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:43 am
Must have money to burn.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:28 am
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:27 am
Oh and FWIW - I am sure Grant will autograph the book. You see him doing that sort of thing at all sorts of events.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:04 am
thomashohner (6/27/2014)
SQLRNNR (6/27/2014)
I would also recommend my book...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 9:04 am
Viewing 15 posts - 2,716 through 2,730 (of 19,560 total)