DB Design :: Can Use Another Server / Disk To Store Files Using FileTable Concept?

May 11, 2015

I tried samples of FileTable in SQL Server 2012 to store files in database. I have following questions.

1. When I right click on FileTable, and say Explore File Table Directory, I was taken to a directory. But if I search the same directory in my server/machine, the directory is not available.

2. Can I use some external server/disk as a directory for FileTable?

3. How easy is to use FileTables using .Net web applications?

View 2 Replies


ADVERTISEMENT

Moving Data Files To A New Disk, Same Server

Jul 23, 2005

Hello, I have been having a bit of trouble finding help on the safestway to move data files to a different disk on the same server. Mosthelp is about moving data files to a different sqlserver. I just wantto move the files to a different drive on the same server. Any helpwould be appreciated.Thanks,David

View 6 Replies View Related

SQL Server 2012 :: Full-Text Search On FileTable

Apr 11, 2014

I am new to Full-Text Searches and FileTables. I am working on a resume search system. I created a FileTable and the Share which contains about 51,000 resumes in Word (DOC/DOCX), PDF and TXT formats that were copied over from our main file server. I followed the instructions on adding the Microsoft Filter Pack 2.0, and all searchable file types are listed in sys.fulltext.document_types.

I have a program that searches resumes by First and Last Name and/or E-mail Address. For a while, we thought it was working fine because we were getting hits, but then we noticed some Names and E-mail Addresses we new existed were not showing up in my CONTAINS queries -- but we verified the documents do exist and the Names exist in the File Name and inside the document along with the E-Mail address.

One example I'm working on now cannot find the First/Last Name with CONTAINS(name,"lastname") in a Word DOC file, but I can find the document using LEFT(name,5) = 'Smith'. It's a Word DOC file. For testing purposes, I opened the DOC file in Word, then used Save As to create a TXT and DOCX file within the same folder. Now, both of those are showing up in the CONTAINS but not the original DOC file.

View 0 Replies View Related

How Can I Store Flat Files In SQL SERVER??

Sep 25, 2005

How can I store flat files in SQL SERVER??

Actually I am planning to prepare a repository of different files like .xls, .pdf, .doc, .ppt etc and then i will have a web interface to access these files. Can anybody guide me, How can i store these flat files in datbase.

View 3 Replies View Related

Store And Receive Html Files In SQL Server

May 1, 2006

I have html files which want to store in database SQL Server with data type image. How store and receive html file from database SQL Server by ASP.NET.
Data type image is pointer 16 bit to file html. So where will content of files html with their image store ?
Can I help you.

View 1 Replies View Related

How To Store The Image Files In Sql Server 2000

Aug 9, 2007

I just want to store pic.bmp file in server using image datatype but don't getting how to do that ..
i want to know about both the actions storing and retrieving from the image data type..
like

create table amit
(
im image,
);


insert into values ()...
select * form Amit will it work...

View 6 Replies View Related

DB Design :: Resizing LDF And MDF Files Of Server Databases

Jul 9, 2015

I want to control the size of ldf files and mdf files of several databases on SQL Server 2008 in my organization (manual increase), but i have a question:

What would be the best practices (best methods) for provisioning a ldf file and mdf file?  Exists any generic formula?

With this i want to avoid the shrink operation and the autogrow of sql server databases...

View 6 Replies View Related

How To Store Flash Files Into The Sql Server 2000 Database

Mar 1, 2008

Hi

How to store flash files into the sql server 2000 database and again display them back in asp.net/C# user interface?thanks 

View 1 Replies View Related

SQL Server 2000 Concept

Jul 20, 2005

Before going in to details i like to understand more about concept anddesign of this database. Most books go directly in to details.Please, can a current admistrator gife me information on this?Thanks in advance,Dick vd Spek email: Join Bytes!

View 1 Replies View Related

Nested Table Concept In SQL Server

May 8, 2004

Hi all,

What is the equivalent for Oracle's nested table concept in SQL Server ?
Is there anything like TABLE( ) function to select from nested table as in Oracle ?

Eg in Oracle :

SELECT t.* FROM TABLE(nested_table_datatype) t;

( like the above query used in Oracle PL/SQL and 'nested_table_datatype' is a table datatype created in Oracle using 'create type ...' syntax )

Please give the equivalent for above...

Thanks,
Sam

View 2 Replies View Related

Files As BLOBS Or On Disk?

Dec 14, 2006

Hi

I wanted to ask a question in terms of design (Performance, scalability, maintenance, flexibility etc.) is it better to refernce a document on the actual file system (on a file server) i.e. from a database link to the actual file at a disk location
e.g. in the database have something like \fileserver2006 estewtext.txt or C: estewtext.txt

or is it better to store all the files in a database as blobs?

The Question i would like to ask is more in the context of desigining a document management system?

View 5 Replies View Related

Multiple Database Files On The Same Disk

May 16, 2007

Hi there



It is obvious that putting multiple database files on different physical disk is better for performance, but what about splitting the data on different files on the same disk?



I have got a database of about 20GB and only a single data file. will I benefit from splitting this file to multiple files on the same disk?

View 10 Replies View Related

Changing The Data Files To Another Disk Partition

May 26, 2004

Hi,

I have a sql server 7 running on a machine with two disk partitions (D: and E:).

The data files xxx.mdf and xxx.ldf are stored in D:, which has very few space available. I want to copy these files to E: but I get an error saying that it is not possible to change the source file of a database. Is it possible to do it or do i have to create another data file in E: and keep the old one in D:?

Thanks in advance,

browser

View 3 Replies View Related

Do I Save Disk Space Storing Images In Db Vs. Loose Files?

Jan 16, 2007

Hello --
I'm building an app that will allow users to create their own photo galleries.  At this point, I'm planning on storing all photos as byte arrays in SQL server image fields.
Besides the organizational benefit, is there a space benefit to doing this?  That is, if I have 1MB of .jpg's, will those same images take up less than 1MB of file space within the database?
One of the reasons I ask is that most hosting plans out there seem to offer more "normal" disk space than is allocated for the database, so I'm trying to make a best plan to accommodate what will probably end up being the biggest disk space consumer in my app (the photos, that is).
Any other recommendations re: this scenario (hosting, best practices) are appreciated.
TIA,
Eric

View 8 Replies View Related

SQL 2012 :: Approach For Using Filetable

Feb 17, 2015

What is the best approach that I can take for the below requirement.

I am designing a tool that basically stores the information of employees. Once a person joins any organization, they need to enter their personal details through this tool.

The basic information that a person is required to enter includes

Firstname, Lastname,DOB, Phonenumber, permanentaddress,tempaddress,etc.,

Along with these details, the user also needs to upload their photo and their educational details and upload all relevant certificates.

I have designed a table for employee personal details as 'Employeedetails' that includes columns

Empid
EmpFirstname,
Emplastname,
EmpPhonenumber,...

Now to store the employee photo and their educational certificates, I wanted to know , what would be the right approach.

I have googled on this and came across the concept of Filetable in sqlsever 2012. But it behaves independent of other tables. How would I store employee details and have a reference to filetable that can store images and other docs in a physical location. Or is it a good way of storing images and docs in DB directly.

View 0 Replies View Related

Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?

Dec 28, 2006

hello,all
          I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure)   from C Disk to D Disk(its space is very large) .
         is it possible to do it ? 
         if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal  report connectstring ) ?
        thanks in advanced!
 
 
 
      

View 1 Replies View Related

DB Design :: Column Store Index And Constraints

Oct 20, 2015

can you have constraints as such [CreateBy] [nvarchar](30) NOT NULL DEFAULT (suser_sname()),on a table that has a column store index in SQL Server 2012,2014, or 2016?

View 3 Replies View Related

Database (model) Cannot Be Opened Due To Inaccessible Files Or Insufficient Memory Or Disk Space

Aug 4, 2015

How to fix this SQL error event logg 17204 and 17207 ?

View 8 Replies View Related

SQL Server, Disk Arrays And Disk IO

May 7, 2004

Hi all,

Ok here goes,

I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.

So my options as I understand it are:

Get Enterprise edition

or

Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.


I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.

Does anyone know how much performance increase I will get from using two arrays as opposed to one?


Any other advice on this scenario would be greatly appreciated.


Thanks

View 4 Replies View Related

SQL 2012 :: Design To Store Different Forms And Form Data?

Oct 17, 2014

I am looking to store the different forms and data in our database. We have several different forms and contains different information. I am looking for different approaches to model this table structure.

Also, I need to make sure the table structure will allow for new forms.

View 5 Replies View Related

SQL 2012 :: Converting From Table With Varbinary To Filetable

Feb 17, 2014

I have a very large database running in a production environment. The backup files are getting to be very difficult to manage. They are at 70gb as of now and growing at a rate of 10gb per month. This is due to document images being stored in the database in one table. I have read a little about a new feature in SQL Server 2012 called Filetable. Can we migrate to SQL Server 2012 and convert to the filetable structure, will this decrease the size of the backups? Would backup of the document images be taken care of by our nightly file system backups now?

View 1 Replies View Related

T-SQL (SS2K8) :: Design Table Which Can Store Education Requirement For Job Vacancy

Aug 13, 2014

This is my table named - CV

*CVID is a primary key

This is my table named - CVEducation

*CV to CVEducation is 1 to Many. CVEducation(CVID) is a foreign key

This is my table named - Level

*LevelID is stored in CVEducation. So, we can know - This education is Diploma or Degree or Masters or so on

This is my table named - StudyField

*StudyFieldID is stored in CVEducation. Som we can know - What kind of Education they have.

This is the example of Job Vacancy 1

1- Need Diploma in Chemistry OR Degree in Chemistry.

2- CGPA at least - 2.5

*May be need to store 2 rows with each CGPA

This is the example of Job Vacancy 2

1- Need Diploma in Commerce OR Diploma in Economics OR Degree in Biology

2- CGPA at least - 2.8

*May be need to store 3 rows with each CGPA

How to design my table to store Job Vacancy Minimal Requirement? I know, there's some cases we cannot computerized. But, at least some of Job Vacancy Requirement we can computerized.

View 5 Replies View Related

SQL 2012 :: Store Attributes / Values In XML Column - Table Design

Oct 29, 2014

I'd like to create a table that will store different order items. Several order items make up one single order. Order items can have 0 or more children (max depth will never be deeper than one). Order items can have up to 150 attributes/values. The way I think this should be done is using XML column instead of the EAV type of model. My table structure currently looks like this:

* child_order_item_id (PK)
* parent_order_item_id (FK to child_order_item_id)
* order_id (FK to Order table)
* product_id (FK to Product table)
* price
* attribute_XML

How my attribute_XML should look like or how to validate the xml.

View 2 Replies View Related

Store Files In DB

Apr 26, 2004

Hi All,
I want to store files (any kind of file) in DB and retrieve them.What is the best method to do it and also please post sample code as I have never done that.
Thanks,
Kumar.

View 1 Replies View Related

Using Sql 7.0 To Store Tiff Files

Feb 22, 1999

Has anyone used sql 7 to store image data? Is it easy to load .tiff files into a sql database using the image datatype? If anyone knows how to do this, please reply.

Thanks !

View 2 Replies View Related

How Do I Store Flat Files

Oct 18, 2006

In my application I am allowing the users attach files. I found the data type "Image", Will this also allow regular file attachments?

Thanks,

Steve C.

View 4 Replies View Related

How To Store Uploaded Files In An SQL Database?

Apr 11, 2007

Hi FriendsCan anyone tell me how to store uploaded files from the user to the SQL database and later give an option of downloading the file probably in the form of a GridView control. How do we write code to allow the user to download the uploaded files. I have written code to upload and store the files into a folder, however, I'm not able to collect data from the folder later and the folder is only accessible offline using the server system which I do not want to happen. Can anyone help me with this?Thanks 

View 1 Replies View Related

Store Files In SQL From An ASP Page Using FileUpload

May 23, 2008

I am almost done with a simple page to have a user select a file (using the FileUpload object), give it a short description and associate it with an item from a listbox.  Thensave these pieces of data to a new row in a SQL DB.
My issue... 
The SQLSmd.ExecuteNonQuery FAILS...
I have got all the fields able to connect and almost save... but for the actual "document" field errors out.  The user can select any type of file (image, word, excel, Powerpoint, etc) for storage into the DB.  I am not storing a referance to a file or the path to a file but the actual file in SQL.In the DB I have the field (Document) set to a type of VarBinary(8000) in the table.  Here is thethe corrisponding code in my app... 
Dim bArray As Byte...bArray = FileUpload1.PostedFile.InputStream.ReadByte()... SQLCmd.Parameters.Add("@Document", Data.SqlDbType.VarBinary, 8000).Value = bArray...iReturn = SQLCmd.ExecuteNonQuery()
ERRORThe first section of the stact trace...
[InvalidCastException: Invalid cast from 'System.Byte' to 'System.Byte[]'.]   System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider) +867   System.Byte.System.IConvertible.ToType(Type type, IFormatProvider provider) +37   System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +408   System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +896

View 7 Replies View Related

How To Store GIF,BMP,JPEG Files In SQLServer.

Jan 19, 2000

Hello friends,

Can anybody pls explain me how I can store GIF,BMP,JPEG files in SQLServer
using Image data type or anything else .Thanks in advance.

Rajesh George.

View 1 Replies View Related

Can We Store HTML/Word/PDF Files In SQL 6.5?

Apr 30, 1999

Hi all,

We've a requirement from our client for converting their paper documents
in electronic format. In order to do so, we need to know whether SQL Server
6.5 has a capability of storing documents in HTML or Word(6.0 or later) or PDF
format into the database?

Any help/link is highly appreciated.

Cheers,

Nimesh

View 2 Replies View Related

How Store Video Files In Sql Database

Jan 24, 2008

how store video files in sql database.Also i want to know cording part

View 3 Replies View Related

Store FILES In SQL Express 2005 With VB.NET

Feb 8, 2007



Hi, I'm a beginner with VB.NET and SQL and I would like to store files (like Images, Document...) in a Table of SQL but I have no idea how to do it.

This is my connection string, and examples of how I do queries, please help me...



Private cn As New SqlClient.SqlConnection

Private cn2 As New SqlClient.SqlCommand

cn.ConnectionString = stringa

cn.Open()

cn2 .Connection = cncn2

CommandType = CommandType.Text



Dim ESEGUI As String

cn2 .CommandText = "INSERT INTO users (nickname) values ('Paolo')

ESEGUI = cn2 .ExecuteNonQuery()



Dim oDr As SqlClient.SqlDataReader

cn2 .CommandText = "SELECT * FROM users WHERE Nickname like 'Paolo'"

oDr = cn2 .ExecuteReader



Thanks

View 1 Replies View Related

DB Design :: Merge MDF And LDF Files Into One File

Jul 14, 2015

In my enviornment i have one database with 6 ndf files and 5 ldf files and one mdf file.Actuvally what i am looking is to merge 6 ndf files into one ndf file and 5 ldf files into one ldf file.is it possible to do like this? , i tried using MOVE and TO option while backup is restorating but getting below error messages.

ERROR:
Msg 3176, Level 16, State 1, Line 4
File 'J:NDFabc.ndf' is claimed by 'Finance_data2'(4) and 'Finance_data1'(3). The WITH MOVE clause can be used to relocate one or more files.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved