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: Today @ 5:25 AM
Points: 3,683, Visits: 4,817
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: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
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: Wednesday, April 09, 2014 9:03 PM
Points: 1,128, Visits: 1,161
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: 2 days ago @ 3:27 AM
Points: 356, Visits: 386
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: Yesterday @ 12:16 AM
Points: 1,231, Visits: 447
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: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
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: Monday, April 14, 2014 3:30 AM
Points: 2,390, Visits: 2,281
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 1,491, Visits: 976
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