FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

sql

Filegroup recommendation

Are there any general recommendations concerning filegroups? My personal point of view is to place large tables in their own filegroups and group smaller, more static, tables in a single filegroup. Is it also good practice to group small and large index in two separate filegroups or should each large index have their own filegroup? Are there any useful links out there concerning filegroups and configuration?http://www.sql-server-performance.com/filegroups.asp