Using Sparse Columns with SELECT ... INTO

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Using Sparse Columns with SELECT ... INTO

28 posts, Page 3 of 3

«««1 2 3

Using Sparse Columns with SELECT ... INTO

Rate Topic

Display Mode

Topic Options

Author

Message

Revenant

Posted Wednesday, August 29, 2012 11:06 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 3,457, Visits: 2,532

Great question! Thanks, Wayne!

Post #1351773

KWymore

Posted Wednesday, August 29, 2012 11:32 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 2,575, Visits: 1,533

Nice question. Thanks!

Post #1351788

churlbut

Posted Wednesday, August 29, 2012 1:29 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:20 AM
Points: 980, Visits: 343

Never used sparse columns in my SQL experience, do any developers here use them frequently?

Post #1351882

EL Jerry

Posted Wednesday, August 29, 2012 2:01 PM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748, Visits: 928

Great question, Wayne. Made me think and research a lot.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

Post #1351900

(Bob Brown)

Posted Thursday, August 30, 2012 4:44 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100

churlbut (8/29/2012)

Never used sparse columns in my SQL experience, do any developers here use them frequently?

I have never used them and am not sure I understand their true applicability.

Post #1352097

L' Eomot Inversé

Posted Sunday, September 02, 2012 11:00 AM

SSCertifiable

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

Good question.

I find it rather surprising that 19% of people to date think the column name doesn't carry over, and 17% think the data type doesn't carry over - I would expect more than 90% of people to know that both those properties are transferred to the new table.

30% of people think that nullability doesn't carry over to the new table, and that's not just surprising it's appalling.

Only 18% of people thought that sparseness carried only, so about as many people understand that sparseness is not copied as understand that the column names are or that data types are. Seems quite bizarre! And about twice as many get sparseness right than nullability, which seems even bizarrer.

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 #1353249

WayneS

Posted Sunday, September 02, 2012 12:04 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 6,368, Visits: 8,231

Thanks Tom,

I have to agree with your assessment. I would have expected the name, data type and null-ability to all be >95%.

I actually felt that this question was so easy, that I asked Steve to not show the number of correct answers... if it showed 3, I felt that everyone would just check those 3. (My thinking was that they would apply deductive reasoning, instead of thinking about the question. I wanted more thought to go into it.)

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 #1353262

jfgoude

Posted Thursday, December 20, 2012 8:05 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 843, Visits: 211

Pure chance.

some way of compensation ?

Post #1398991

« Prev Topic | Next Topic »

28 posts, Page 3 of 3

«««1 2 3

Permissions