Browse by Tags

SQL Server 2008 - Replication and Filestream, are both supported together?

Published 26 May 8 4:1 AM | SSQA.net

Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...

Filed under: sql server, replication, BOL, features, support, filestream

SQL Server FILE STREAM error: Share name '<name>' is not valid or is already in use. Try a different share name or delete the existing share

Published 21 May 8 3:3 AM | SSQA.net

In most of the newsgroups and forums I have seen asking how to store/manage the image/video/documents/files within the SQL Server database. SQL Server 2008 version has addressed this issue by enabling the FILE STREAM feature that will integrate the data...

Filed under: sql server, 2008, share, sp_configure, filestream, operating system

SQL Server CTP6 Error FILESTREAM feature is disabled - save your day!

Published 16 May 8 9:16 AM | SSQA.net

I have had annoying moment when I'm trying to restore the sample database AdventureWorks on the test database server that consists SQL Server 2008 CTP6 and previous to this I have tried bits and pieces on FILESTREAM, but it seems CTP6 has changed...

Filed under: sql server, blogs, filestream

SQL Server 2008: FILESTREAM performance

Published 9 March 8 12:45 PM | SSQA.net

During the various courses I've been teaching, people are interested in how FILESTREAM performance compares with storing BLOBs in the database itself. I have some performance graphs based on measurements the dev team made - these have been presented...

Filed under: performance, filestream, SQL Server 2008

SQL Server 2008 November CTP 5 - next instalment is available

Published 20 November 7 2:49 AM | SSQA.net

Here comes another instalment of SQL Server 2008 for the CTP fans. The SQL Server 2008 November CTP has been released to the connect.microsoft.com website and is available for download here . One of the improvements in this build is the ability to persist...

Filed under: sql server, microsoft, community, 2008, connect, spatial, best practice, business intelligence, filestream, ctp5

Filestream datatype - what it is?

Published 1 October 7 3:31 AM | SSQA.net

My question is have you looked into the CTP4 Books online for SQL 2008? This is new to SQL Server arena, the FileStream data type which allows large binary data to be stored in the file system and yet remain an integral part of the database with transactional...

Filed under: sql server, performance, microsoft, 2008, ctp, new, data type, filestream