Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Using sys.index_columns Expand / Collapse
Author
Message
Posted Monday, December 19, 2011 9:18 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:59 AM
Points: 411, Visits: 1,394
Comments posted to this topic are about the item Using sys.index_columns



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


If you don't have time to do it right, when will you have time to do it over?
Post #1224133
Posted Monday, December 19, 2011 9:47 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 12:58 AM
Points: 1,904, Visits: 2,771
Good one, thanks

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1224137
Posted Monday, December 19, 2011 10:20 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 20,484, Visits: 14,138
nice question



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1224142
Posted Monday, December 19, 2011 11:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 5,473, Visits: 23,557
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

Before posting a performance problem please read
Post #1224160
Posted Tuesday, December 20, 2011 12:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 4,252, Visits: 3,334
bitbucket-25253 (12/19/2011)
A lot of reading, but a nice question which will certainly teach those who answer incorrectly.

Thanks

+1 - thanks!
Post #1224180
Posted Tuesday, December 20, 2011 12:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
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)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1224185
Posted Tuesday, December 20, 2011 12:42 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:59 AM
Points: 411, Visits: 1,394
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
Posting Performance Based Questions - Gail Shaw
Hidden RBAR - Jeff Moden
Cross Tabs and Pivots - Jeff Moden
Catch-all queries - Gail Shaw


If you don't have time to do it right, when will you have time to do it over?
Post #1224196
Posted Tuesday, December 20, 2011 12:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:59 AM
Points: 5,801, Visits: 8,018
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1224201
Posted Tuesday, December 20, 2011 1:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 12,228, Visits: 9,204
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!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1224219
Posted Tuesday, December 20, 2011 3:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 41,559, Visits: 34,485
Hmm, this looks familiar.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1224292
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse