Tech Off Post

Single Post Permalink

View Thread: Why the need of NTFS as base of SQLServer/WinFS?
  • User profile image

    Right, you can put it out on a raw format drive, but virtually never seen that done in actual practice. Not sure why.

    Actually, the NTFS choice is far better than FAT for a number of reasons, performance being just one of them. There's block size differences and so on. There's lots of optimization tricks you can do with regard to SQL Server and disks, see: [link][/link]

    I think its most accurate to think of WinFS as being an NTFS meta data database and that's about it. It feeds of journaling events and streams. Beyond that, its more details than I want to dive into right now Smiley