Plan Guides

Question

Plan Guides

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
October 18, 2014 at 11:39 am

#72518

Comments posted to this topic are about the item Plan Guides
October 20, 2014 at 3:40 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22680

October 20, 2014 at 12:57 am

#1753405

Very interesting!

Thx!

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Thank you for the post, Steve, very interesting one.

(..in previous month I was reading this article http://blogs.msdn.com/b/igorpag/archive/2014/01/15/sql-server-2014-inside-hekaton-natively-compiled-stored-procedures.aspx and came across "sql_handle" and "plan_handle".. then started exploring in the local_help and with no relation I was reading plan guides. While answering the qtod I didn't recall any of these three types, after reading the choices I was sure, somehow. good it worked :-))

Line from the help. Interesting.

QUOTE

Plan guides can be useful when a small subset of queries in a database application provided by a third-party vendor are not performing as expected.

UNQUOTE

(2014 has lots of features, not sure when we will have real-time exposure... probably we may end up creating our own scenarios just to test these stuff.. :-D)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 4

Dana Medley

SSCertifiable

Points: 6764

October 20, 2014 at 7:19 am

#1753487

Thanks for the question!

Everything is awesome!

Mike Hays SSCommitted Points: 1871 More actions · Answer 5

Mike Hays

SSCommitted

Points: 1871

October 20, 2014 at 8:07 am

#1753507

Learned something new...

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 6

Nice question, Steve, thanks. I didn't know about those. When your question mentioned SQL Server 2014, I thought it was something new to 2014, but it looks like it goes back to 2005 (with the same three available types).

Why does your explanation reference SQL Server 2041? Do you have some inside information about a version coming out 27 years from now? :hehe:

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

A very interesting question and I got to learn something new, which is always the goal with the QOTD. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

I had no idea about this, so learnt somthing new 2day, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

I didn't know about this. I enjoy learning something new. Thank you.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

It's an interesting feature. But I can't imagine ever wanting to use it.

Tom

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 11

SQL_Hunt

SSC-Dedicated

Points: 33518

October 23, 2014 at 9:16 am

#1754378

Simple and Nice question..Thanks Steve.

Thanks.

j9data Newbie Points: 1 More actions · Answer 12

Hi i am trying to turn a table hint into a plan guide as i can not change 3rd party code.

table hint

select .........from table x with(INDEX (<index_NAME)

for plan guide i can not find an example of the sql i would need to use

@hint = N'OPTION....?

please could someone give me the correct syntax

Thanks