MSDB Tables/Views

Question

MSDB Tables/Views

Viewing 15 posts - 16 through 30 (of 30 total)

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 1

Nils Gustav Stråbø (3/6/2012)
I don't complain about the functionality of that specific view, I'm just being an annoying pedantic 😀 Every QOTD has one.

:laugh:

However, if you were really pedantic, you would have realized that the phrasing of the question is: "Which table/view contains a row ...", not "Which table/view returns a row ...". The WHERE clause only affects what the view returns, not what it (or the underlying table) contains.

(So the true pedantic post would have stated that a view never contains rows, unless it is an indexed view. And it would have included a whiney remark about demanding back the oh so precious points that you were robbed off)

PS: To John Hanrahan - please take this comment as I intended it, as a stab to the annoying pedantic that, indeed, appears to be inevitable on the QotD topics. I did in fact enjoy this question very much, and I think it is an excellent question. I hope to see more questions from you in the future.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 2

I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:

I promise to never try to be one again...

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

Nils Gustav Stråbø (3/6/2012)
I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:
I promise to never try to be one again...

That may be a difficult promise to keep .....

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]

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

Nils Gustav Stråbø (3/6/2012)
I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:
I promise to never try to be one again...

Practice makes perfect!

Wait ... did I just say that?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

William Soranno SSCommitted Points: 1713 More actions · Answer 5

Nils,

You put the complaint in before I could.

Thank you.

Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92

David Burrows SSC Guru Points: 65142 More actions · Answer 6

Nils Gustav Stråbø (3/6/2012)
I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:
I promise to never try to be one again...

The pedantic was fine, it was the whining that was pathetic 😛

This is also a joke....

honest....

no...

WHACK...

ouch! :pinch:

Far away is close at hand in the images of elsewhere.
Anon.

John Hanrahan Hall of Fame Points: 3825 More actions · Answer 7

Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.

At least I got a point today!

John

David Burrows SSC Guru Points: 65142 More actions · Answer 8

John Hanrahan (3/6/2012)
Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.
At least I got a point today!
John

Kudos to you John for submitting 😀

I was thinking of posting a lousy, incorrect buggy question, to get slated and flamed, just so I would get noticed :w00t:

Far away is close at hand in the images of elsewhere.
Anon.

zymos SSCommitted Points: 1960 More actions · Answer 9

Nice question. Reviewed to database mail topic once again in a while.

Thanks

Revenant SSC-Forever Points: 42467 More actions · Answer 10

This one forced me to go and dig a bit. Thanks, John!

Cliff Jones SSChampion Points: 10547 More actions · Answer 11

David Burrows (3/6/2012)
John Hanrahan (3/6/2012)
Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.
At least I got a point today!
John
Kudos to you John for submitting 😀
I was thinking of posting a lousy, incorrect buggy question, to get slated and flamed, just so I would get noticed :w00t:

Thanks John, David and Nils for such an entertaining question and discussion.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 12

David Burrows (3/6/2012)
John Hanrahan (3/6/2012)
Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.
At least I got a point today!
John
Kudos to you John for submitting 😀
I was thinking of posting a lousy, incorrect buggy question, to get slated and flamed, just so I would get noticed :w00t:

There's still plenty of room available for future QotD's, you know!

(sharpens knives)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Ken SSCoach Points: 17191 More actions · Answer 13

Thanks for the QOTD John. I too had to go digging on this one.

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Let's see now: can I do better than Nils? 😛

Well it's a good question, a good explanation, utterly incorrect answer (but Hugo already pointed out that Nils should have said that), I can't whine about not getting the point because I did get it, so where on earth do I go from there? :unsure:

Ah, yes, got it: given the second sentence of the explanation it would perhaps have been useful to include a reference to http://msdn.microsoft.com/en-us/library/ms190630.aspx in addition to the reference given. 😀

Tom

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 15

Good question. Thanks for submitting.

http://brittcluff.blogspot.com/