Charles Kincaid (4/1/2008)
Anders Pedersen (4/1/2008)
...Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS for IO functions and managed those themselves. ...
Yep. Same for 7 IIRC. 2000 objects if it's data or log files are compressed via NTFS. I think that this might still be true for 2005.
Ah well. So much for the Dyson Principle: "I just think that things should work properly."
I'm actually not sure they've ever stopped thinking on this. The original concept of Longhorn's File system was essentially supposed to be a SQL Server database of sorts. In other words - the DB IS the file system. I don't think that survived, but it's a very compelling thought.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?