TSQL 2012 #1

Question

Post reply

TSQL 2012 #1

Ron McCullough

SSC Guru

Points: 63877
More actions
December 27, 2012 at 10:03 pm

#272390

Comments posted to this topic are about the item TSQL 2012 #1
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]
December 28, 2012 at 5:17 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 19 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Thanks Ron for another one on SS-2012. Keep them pouring 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

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

Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

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 3

Koen Verbeeck (12/27/2012)
Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

+1

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Koen Verbeeck (12/27/2012)
Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

I thought the explanation provided was sufficient, for after all it says:

@include_browse_information
@include_browse_information is type bit. If set to 1, each query is analyzed as if it has a FOR BROWSE option on the query. Returns additional key columns and source table information.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SanDroid SSChampion Points: 10068 More actions · Answer 5

Koen Verbeeck (12/27/2012)
Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

+1

SanDroid SSChampion Points: 10068 More actions · Answer 6

bitbucket-25253 (12/28/2012)
Koen Verbeeck (12/27/2012)
Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂
I thought the explanation provided was sufficient, for after all it says:....

[/quote]

Ron your explination only says:

This dynamic management function takes an @object_id as a parameter and describes the first result metadata for the module with that ID.

The Linked MSDN article has the text you quoted, not your explination..... 😛

SanDroid SSChampion Points: 10068 More actions · Answer 7

Nice question with a good use of the new 2012 Adventure Works database.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Thanks for the question.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Nice easy question.

The explanation is a bit sparse though, as Koen said.

Tom

john.arnott SSChampion Points: 11882 More actions · Answer 10

This is a straight-forward enough QOD, I suppose. But I do wonder what the point is of having the "Include_browse_information" switch to begin with. Why would MS think it necessary to provide a control for whether those five columns are populated in the results?

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

Fine learning... thank you for the question. (this is completely new for me) 🙂

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

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 12

PChiragS

SSCarpal Tunnel

Points: 4965

December 30, 2012 at 7:07 pm

#1572420

Thanks for the question..

sqlnaive SSCoach Points: 17437 More actions · Answer 13

Great question. Got to know about this DMV from this question. Got just 1 point but it was worth.