1 ms latency is outstanding, if true. How far apart are your data centers?

IIRC you can do it from the IIS management console. Don't recall the specifics. But that's where you would start.

The answer is correct but the question is wrong. The question asks "how many sub directories?" The correct answer to that is, "no limit". The answer "limit...

This is a good start, however I do not see any error handling. Do you just let the package fail? If so, how would you troubleshoot a failure?

The explanation:

The maximum number of subdirectories in a filetable is 255 and The maximum number of subdirectories is limited only by disk space are both incorrect. Strangely enough the limit...

The real drag is that there is no token (JOBNAME). That would be handy. If you want the job name in several packages called from different jobs, you have to...

Thanks Koen! dunno where I went wrong the first time or second. Third time lucky!

g.britton (10/1/2015)

---

timwell (10/1/2015)

---

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...

timwell (10/1/2015)

---

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...

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

Bill_Pearson (9/30/2015)

---

Thanks for the input. MDX often challenges people who have mastered SQL, for more reasons than one. The functions you mention are but a few examples of...

Thanks for this series Bill. Just learning MDX at the moment so timely for me.

Have to say though, that I wish the originator had stayed much closer to SQL...

sknox (9/16/2015)

---

samot-dwarf (9/16/2015)

---

Even if he would use the correct order, he must not use CHECKSUM because it is not case sensitive (if you are using the default collation for your...

Steve Jones - SSC Editor (9/15/2015)

---

The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there...

sknox (9/14/2015)

---

I think the explanation is just plain wrong.

I don't see anything which would produce data types or numbers with the precision and scale of (2,1) or (1,1) --...