Hi guys, in my company is being developed a web application base on SQL Server 2008 and .NET framework 3.5, where it extracts information regarding employees like Name, Age, Position, ExtractedDate and some other data. Recently was needed to include the employee's pictures that it doen't matter the sizes, and I knew a little bit about the FILESTREAM Data type, so I started to investigate regarding it and, I try to implement it, but reading this article I saw that it impacts to the Query performance, so I have the question on how to implement this kind of Data in order to impact less posible the preformance?? sholud I do another table where store only the FILESTREAM Data type and have a FK column from my Employee table in order to use it only in the queries that is necessary?? Or could I have the FILESTREAM Data type in the same Employee table and only create an index??

this is my Employee table:

CREATE TABLE [tln].[T_TRABAJADOR](

[curp] [char](18) NOT NULL,

[id_rpe] [varchar](5) NOT NULL,

[nombre] [varchar](100) NOT NULL,

[edad] [tinyint] NOT NULL,

[fecha_ingreso_cfe] [smalldatetime] NOT NULL,

[puesto_titular] [smallint] NOT NULL,

[id_proceso] [char](2) NOT NULL,

[id_area] [char](5) NOT NULL,

[Fecha_Extraccion] [smalldatetime] NOT NULL

) ON [PRIMARY]

ALTER TABLE [tln].[T_TRABAJADOR] ADD CONSTRAINT [PK_T_TRABAJADOR] PRIMARY KEY CLUSTERED

(

[curp] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

So I don't know if include the Photo Column in the same table or in another table something like this:

Opt 1 :

CREATE TABLE [tln].[T_TRABAJADOR](

[curp] [char](18) NOT NULL,

[id_rpe] [varchar](5) NOT NULL,

[nombre] [varchar](100) NOT NULL,

[edad] [tinyint] NOT NULL,

[fecha_ingreso_cfe] [smalldatetime] NOT NULL,

[puesto_titular] [smallint] NOT NULL,

[id_proceso] [char](2) NOT NULL,

[id_area] [char](5) NOT NULL,

[Fecha_Extraccion] [smalldatetime] NOT NULL,

[GUID]UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE,

[Photo]VARBINARY(MAX) FILESTREAM NULL,

) ON [PRIMARY]

Opt 2:

CREATE TABLE [tln].[T_TRABAJADOR_RECURSOS]

(

[GUID]UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE,

[curp] CHAR (18) NOT NULL FK,

[Photo]VARBINARY(MAX) FILESTREAM NULL,

)

Regards guys 🙂 and I hope u could help me, I'm trying to consume these new features.

sorry for my bad english :(.