<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Richard Rozema
»
Using sys.index_columns
24 posts, Page 2 of 3
««
1
2
3
»»
Using sys.index_columns
Rate Topic
Display Mode
Topic Options
Author
Message
paul s-306273
paul s-306273
Posted Tuesday, December 20, 2011 3:48 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 4:24 AM
Points: 1,158,
Visits: 642
Good question.
Post #1224312
R.P.Rozema
R.P.Rozema
Posted Tuesday, December 20, 2011 3:58 AM
SSC-Addicted
Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:01 AM
Points: 406,
Visits: 1,364
:). 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
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 #1224321
Britt Cluff
Britt Cluff
Posted Tuesday, December 20, 2011 5:40 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,558,
Visits: 247
Tough question. I missed it but learned something today.
http://brittcluff.blogspot.com/
Post #1224356
Stuart Davies
Stuart Davies
Posted Tuesday, December 20, 2011 7:48 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 2,473,
Visits: 2,131
Good question
Had to come back to this one a couple of times before being sure I was right
-------------------------------
Posting Data Etiquette - Jeff Moden
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
Post #1224437
Cliff Jones
Cliff Jones
Posted Tuesday, December 20, 2011 8:02 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:11 PM
Points: 3,390,
Visits: 3,403
Great question, thanks.
Post #1224447
Carla Wilson-484785
Carla Wilson-484785
Posted Tuesday, December 20, 2011 8:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:00 PM
Points: 1,349,
Visits: 1,737
Several good tidbits in here, including demonstrating how important code formatting is for readability. :)
Thanks for a good question.
Post #1224475
SQLRNNR
SQLRNNR
Posted Tuesday, December 20, 2011 8:57 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
GilaMonster (12/20/2011)
Hmm, this looks familiar.
Seemed familiar from a tweet conversation involving you.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
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 #1224511
SQLRNNR
SQLRNNR
Posted Tuesday, December 20, 2011 8:58 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
R.P.Rozema (12/20/2011)
:). 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.
Meh - not too concerned about the answer format. Still a good question.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
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 #1224513
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Tuesday, December 20, 2011 9:19 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176,
Visits: 778
tks - good question
Post #1224542
Kenneth.Fisher
Kenneth.Fisher
Posted Tuesday, December 20, 2011 10:32 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:31 AM
Points: 3,367,
Visits: 1,563
Good question.
The formatting didn't bother me a whole lot since I did what I usually do with this type of question. I ran along comparing them line by line to see what the differences were. Once I knew what the differences were I knew what columns you were testing on and could easily go from there. I never really tried to interpret the queries as a whole.
I do love system table questions though. Always a lot of fun.
Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post -->
www.SQLStudies.com
Post #1224634
« Prev Topic
|
Next Topic »
24 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
