Nulls in the FileTable

Question

Post reply

Nulls in the FileTable

Andy Warren

SSC Guru

Points: 119902
More actions
October 1, 2015 at 12:05 am

#311936

Comments posted to this topic are about the item Nulls in the FileTable
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
October 1, 2015 at 2:18 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

SADSAC SSCrazy Points: 2401 More actions · Answer 1

According to books online, last_access_time is a not null field, with a default of Current time

RKaram SSCommitted Points: 1518 More actions · Answer 2

Is really this is the correct answer ?

:w00t::w00t::cool::cool:

rkaram

Mauricio_ SSCrazy Points: 2935 More actions · Answer 3

According to https://technet.microsoft.com/en-us/library/gg492084(v=sql.110).aspx

last_access_time is datetime2(4) not null.

edwardwill SSCertifiable Points: 5851 More actions · Answer 4

According to your own cited source, last_access_time is NOT NULL.

https://msdn.microsoft.com/en-us/library/gg492084.aspx

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

I was also looking at https://msdn.microsoft.com/en-GB/library/gg492084.aspx which disproves the answer.

HappyGeek SSCoach Points: 18729 More actions · Answer 6

I use a Filetable and despite what MS may say on the issue the table definition does appear to suggest that last_access_time can be NULL and is in fact (datetimeoffset(7), NULL) - see screen shot.

whether there are differences between versions and editions of SQL I have not yet checked, but it would make logical sense to allow NULL as there may be documents that are never accessed.

...

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

Never used "FileTable" b4, so learned somthin new 2day, thanx Andy.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

Damn you MSDN!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

g.britton SSChampion Points: 13863 More actions · Answer 9

Sorry Andy, you got it wrong. last_access_time is defined as datetime2(4) not null, according to the source you cited

Gerald Britton, Pluralsight courses

timwell SSCertifiable Points: 5315 More actions · Answer 10

With regard to last_access_time, there is a note from a Michael Quinlan on the version of the FileTable Schema page that comes up on the search in technet with some corrections:

https://technet.microsoft.com/en-us/library/gg492084(v=sql.110).aspx

He also mentions that Name should say "not null"

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

I guess I shouldn't be surprised that MSDN is wrong - it isn't the first time.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 12

With quick analysis on the field names, selected the right ones. (now just wondering- say if I have checked "all of the above", now what other two check boxes I have to select... hmmm that's a tuffy...)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

kslentz Say Hey Kid Points: 690 More actions · Answer 13

Not a good question for 2008 R2 users with no FileTable experience. Researching on MSDN (curious about the FileTable and the structure) gives an incorrect answer. Bummer!!