Query Hints

Question

Query Hints

Steve Jones - SSC Editor

SSC Guru

Points: 736078
More actions
December 22, 2008 at 11:35 pm

#63480

Comments posted to this topic are about the item Query Hints

Viewing 9 posts - 1 through 8 (of 8 total)

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

Ronald H SSCarpal Tunnel Points: 4053 More actions · Answer 1

Last of the 3 questions all the options were true... I hope to see some questions where none or only 1 option is true... I'm going to click them all on by default by now...

Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 2

OK, I was lazy. Didn't want to make something up and find it was real.

I'll be sure the next few I write aren't like that! 😛

Chad Crawford SSChampion Points: 11610 More actions · Answer 3

Hey Steve - here's a thought for the QOD for tomorrow... or another time. I noticed you swapped out an undisclosed part of the SSC logo for a present - "Which of the following images used to be in the spot currenly occupied by the present". 🙂 Of course, it would only work for those taking the quiz the next few days, after that they'd just have to look up to see what was there.

Chad

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 4

That's good! I'll have to get some more images made with other things so I can keep confusing you.

Anipaul SSC-Insane Points: 24681 More actions · Answer 5

r.hensbergen (12/23/2008)
Last of the 3 questions all the options were true... I hope to see some questions where none or only 1 option is true... I'm going to click them all on by default by now...

It's makes our life easier 😉

Ralf Dietrich SSChasing Mays Points: 660 More actions · Answer 6

I feel sorry - i was on a tricky ice.

In the headline you wrote query hint - and there is no QUERY hint with remote

http://msdn.microsoft.com/en-us/library/ms181714.aspx

but in the question you wrote (correct) JOIN hint

and yes - I was to fast and just reading the headline

"remote" IS a JOIN hint

http://msdn.microsoft.com/en-us/library/ms173815.aspx

Was it a "quick" headline ("query hints" instead of "hints") or the idea behind the question?

hints: http://msdn.microsoft.com/en-us/library/ms187713.aspx

-- not to forget TABLE hints

http://msdn.microsoft.com/en-us/library/ms187373.aspx

Good to review - and to remember to handle with care

SanjayAttray SSChampion Points: 13157 More actions · Answer 7

I wasn't sure about " Remote " option. But since from last two days all options are correct, I selected Remote option.

Can some one post a sample query or syntax which shows hints on Remote query? I couldn't find anywhere.

Appreciated.

SQL DBA.

Vinay Thankur SSCarpal Tunnel Points: 4178 More actions · Answer 8

IS Remote introduce in 2008

Thanx.
Vinay

http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay