Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Using Sparse Columns and Sparse Column Sets
Add to briefcase
27 posts, Page 1 of 3
123»»»

Using Sparse Columns and Sparse Column Sets Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
WayneS
Posted Tuesday, September 04, 2012 9:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:35 PM
Points: 6,369, Visits: 8,232
Comments posted to this topic are about the item Using Sparse Columns and Sparse Column Sets

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1354301
Lokesh Vij
Posted Tuesday, September 04, 2012 11:00 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:02 AM
Points: 1,174, Visits: 1,250
Nice question Wayne..

The only exception when insert will fail is when one tries to insert in a column (col1/col2/col3) and TblColumnSet (COLUMN_SET) in one go

Cheers

~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter
Post #1354316
demonfox
Posted Tuesday, September 04, 2012 11:07 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076
nice question . get to learn about the column sets.

thanks

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1354317
Koen Verbeeck
Posted Wednesday, September 05, 2012 12:15 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373, Visits: 6,470
Great question Wayne.


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 #1354333
Raghavendra Mudugal
Posted Wednesday, September 05, 2012 12:41 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 445, Visits: 1,197
Thank you. Nice.

(same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between these two )

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1354337
Erav
Posted Wednesday, September 05, 2012 1:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 8:36 AM
Points: 165, Visits: 110
Nice Question Wayne. Thanks.

-Erav
Post #1354347
Stewart "Arturius" Campbell
Posted Wednesday, September 05, 2012 1:17 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:48 AM
Points: 3,125, Visits: 4,311
Good question, thanks, Wayne.
Learned something new.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1354348
L' Eomot Inversé
Posted Wednesday, September 05, 2012 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 7,096, Visits: 7,156
Nice question.

Raghavendra Mudugal (9/5/2012)
same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between these two )

Well, not really "same", it's a very diffefrent question.
But certainly anyone who had seen the first one would be aware that the last insert doesn't cause an error, and deducing that three 2-row inserts and one 1-row insert will between them insert 7 rows is not very difficult. So it might have been better if these two questions had appeared in the opposite order.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1354368
Raghavendra Mudugal
Posted Wednesday, September 05, 2012 2:20 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 445, Visits: 1,197
L' Eomot Inversé (9/5/2012)
Nice question.

Raghavendra Mudugal (9/5/2012)
same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between these two )

Well, not really "same", it's a very diffefrent question.


Not sure what I am missing here, but the both questions has the same table structure and then same data to inserts, in the end the previous question uses the SELECT INTO where the data is been copied to the new table and objective of the question completely relays on the table2. Here in this question it is just the first part of the previous question, where the new table creation is been avoided and then the objective of the question here mainly focuses on the XML column set which again can be seen working properly with no errors in the previous one.

I am not sure how it can be very different.

thank you for your reply.

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1354376
Hugo Kornelis
Posted Wednesday, September 05, 2012 3:34 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 5,237, Visits: 7,044
Raghavendra Mudugal (9/5/2012)
L' Eomot Inversé (9/5/2012)
Nice question.

Raghavendra Mudugal (9/5/2012)
same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between these two )

Well, not really "same", it's a very diffefrent question.


Not sure what I am missing here, but the both questions has the same table structure and then same data to inserts, in the end the previous question uses the SELECT INTO where the data is been copied to the new table and objective of the question completely relays on the table2. Here in this question it is just the first part of the previous question, where the new table creation is been avoided and then the objective of the question here mainly focuses on the XML column set which again can be seen working properly with no errors in the previous one.

I am not sure how it can be very different.

thank you for your reply.


This question (the second, chronologically) basically asked which of the insert formats used would fail and which would work.
The other question (the first, chronologically) used these insert formats to set up sample data and than asked what the effect of a certain statement on that sample data would be. That question is completely different. The sample data could have been given in a variety of other formats without affecting the question.

So yes, they are different questions. And I think they are both good by themselves. But in combination and in the order they are published here, this (second) question is weak: the same methods of inserting were used for the first question and the rest of that question implied that they would run error-free, so anyone who looked more than casually at that question is bound to get this one right. Had the order been reversed, then both questions would have been good.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1354400
« Prev Topic | Next Topic »

Add to briefcase
27 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.