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: 2465 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: 5911 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: 113523 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: 259155 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!!

Nulls in the FileTable

Cookies on SQLServerCentral