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 1234»»»

File Tables Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 9:13 PM


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: Yesterday @ 8:37 AM
Points: 3,905, Visits: 5,079
Comments posted to this topic are about the item File Tables

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1386663
Posted Monday, November 19, 2012 9:38 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Its is always wonderful to learn new things about SS 2012. Thanks for posting this question

~ 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 #1386669
Posted Monday, November 19, 2012 10:08 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
After reading the file table, I fell on varbinary(max) ..
need to read it again ..

thanks for the question..


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1386679
Posted Tuesday, November 20, 2012 1:49 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
Good question, thanks!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
Post #1386727
Posted Tuesday, November 20, 2012 1:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 374, Visits: 398
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..
need to read it again ..


+1
Post #1386734
Posted Tuesday, November 20, 2012 2:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 12:40 AM
Points: 1,314, Visits: 476
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..
need to read it again ..

thanks for the question..

+1
Post #1386741
Posted Tuesday, November 20, 2012 2:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Answer looks obvious, but obviously I'm wrong...
Post #1386746
Posted Tuesday, November 20, 2012 3:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..
need to read it again ..

thanks for the question..


+1


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1386769
Posted Tuesday, November 20, 2012 3:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:25 AM
Points: 2,495, Visits: 2,376
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..
need to read it again ..

thanks for the question..


+1
Post #1386776
Posted Tuesday, November 20, 2012 3:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:33 AM
Points: 1,656, Visits: 1,087
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..
need to read it again ..

thanks for the question..


I didn't see anything about that much either - it seems we are not alone on that failing...
Post #1386782
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse