Using sys.index_columns

Question

Using sys.index_columns

R.P.Rozema

SSChampion

Points: 12317
More actions
December 19, 2011 at 9:18 pm

#261932

Comments posted to this topic are about the item Using sys.index_columns

Posting Data Etiquette - Jeff Moden[/url]
Posting Performance Based Questions - Gail Shaw[/url]
Hidden RBAR - Jeff Moden[/url]
Cross Tabs and Pivots - Jeff Moden[/url]
Catch-all queries - Gail Shaw[/url]

If you don't have time to do it right, when will you have time to do it over?

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

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Good one, thanks

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

nice 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

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

A lot of reading, but a nice question which will certainly teach those who answer incorrectly.

Thanks

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]

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

bitbucket-25253 (12/19/2011)
A lot of reading, but a nice question which will certainly teach those who answer incorrectly.
Thanks

+1 - thanks!

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

Nice question and I definately learned something, but quite an awful format 🙂

(I had to copy paste each answer into SSMS so I could read it better)

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

R.P.Rozema SSChampion Points: 12317 More actions · Answer 6

Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.

Posting Data Etiquette - Jeff Moden[/url]
Posting Performance Based Questions - Gail Shaw[/url]
Hidden RBAR - Jeff Moden[/url]
Cross Tabs and Pivots - Jeff Moden[/url]
Catch-all queries - Gail Shaw[/url]

If you don't have time to do it right, when will you have time to do it over?

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

R.P.Rozema (12/20/2011)
Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.

That is indeed the best option. The formatting options for the question are adequate; for the answer options, formatting is non-existant.

Thanks for submitting a great question, and I hope to see more questions coming 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/

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

R.P.Rozema (12/20/2011)
Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.

That is indeed the best option. You can type in the answers in SSMS and take a screenshot. That way we all have the advantage of the color coding 🙂 (and it makes it a bit harder to just run the statements).

Thanks again for the question, hopefully the first of many to come!

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Hmm, this looks familiar. 😉

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

paul s-306273 SSChampion Points: 10730 More actions · Answer 10

paul s-306273

SSChampion

Points: 10730

December 20, 2011 at 3:48 am

#1423535

Good question.

R.P.Rozema SSChampion Points: 12317 More actions · Answer 11

:). Yes, that's how this question got to be: I did it wrong myself. And so far almost half of the people who tried, had it wrong too. To their avail, the ill-formatted answers don't help them...

Once more, thanks for your assistance.

Posting Data Etiquette - Jeff Moden[/url]
Posting Performance Based Questions - Gail Shaw[/url]
Hidden RBAR - Jeff Moden[/url]
Cross Tabs and Pivots - Jeff Moden[/url]
Catch-all queries - Gail Shaw[/url]

If you don't have time to do it right, when will you have time to do it over?

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 12

Tough question. I missed it but learned something today.

http://brittcluff.blogspot.com/

Stuart Davies SSCoach Points: 19505 More actions · Answer 13

Good question

Had to come back to this one a couple of times before being sure I was right

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Cliff Jones SSChampion Points: 10547 More actions · Answer 14

Cliff Jones

SSChampion

Points: 10547

December 20, 2011 at 8:02 am

#1423651

Great question, thanks.