Bug? Legend values same color

I when setting the background color for a data point programatically, I want
two colors. 'Firebrick' for bad values and 'ForestGreen' for good. So I
have a simple global function to handle this. Sometimes though, for no
explainable reason, even though my bar chart has green and red series, the
legend shows red for each of the two existing series. How can this be? The
series colors on the chart should always by default correspond with the
colors rendered for the legend.
I will provide you any information required to get to the bottom of this.
For starters, I'm running Report Services SP2.Please someone help me on this one. I am fairly certain this is a bug in
reporting services but need help to confirm this.

Broadcast existence of SQL Server

Hi All:

Does anyone know where to find the property that disables the broadcast of the sql server from the point where you do not see the server show up in the list when one goes to

"New SQL Server Registration" -> "..."

beside the "Server" field. The dialog itself is titled "Registered SQL Server Properties". Assume both SQL Servers are both behind the firewall.While it isn't 100%, you can get a good start by disabling the Named Pipes Broadcast (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_97cb.asp) for SQL Server.

-PatP|||Thanks for the reg key option. For some reason I seemed to remember seeing an option where you can set this from the enterprise UI. I could be wrong but does anyone remember anything along those lines.|||Thanks for the reg key option. For some reason I seemed to remember seeing an option where you can set this from the enterprise UI. I could be wrong but does anyone remember anything along those lines.
Start->Programs->SQL Server->Server Network Utility; in the General Tab, select TCPIP. Select Properties, Check the option HIDE SERVER.
it would force SQL stop broad casting the port it's listening to.|||Start->Programs->SQL Server->Server Network Utility; in the General Tab, select TCPIP. Select Properties, Check the option HIDE SERVER.
it would force SQL stop broad casting the port it's listening to.I think that is only a choice for named instances of SQL Server.

-PatP|||I think that is only a choice for named instances of SQL Server.

-PatP
Hi. This is what BOL says.

[Hide server

Select to hide the instance of Microsoft SQL Server. When you hide an instance of SQL Server, responses to broadcasts from clients attempting to enumerate those instances of SQL Server present on the network are disabled.]
named instance is not exclusively mentioned; have to test the scenario

Breakpoint in child-package triggered on first execution only.

I have a child package which is executed several times within the same SSIS ETL. I have placed a break point on one of the child package's tasks, set to trigger on a PreExecute() event. The first time the child package is invoked, the breakpoint is triggered. However, on each successive invocation the breakpoint is ignored. Does anybody know if this behaviour is normal? Thanks in advance!

This is a known issue and we are aware of the bug. Thanks

Breaking Point

Hi,
We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
2003 (Standard Ed, 32bit) for our company.
I would like to know the breaking point of the following so we can foresee
any problems and perhaps be able to avoid them.
There will be a huge amount of pictures to be stored in our server. Where
will pics be stored? as BLOBS in SQL or as files?
I am new to this and appreciate any info. We have been ripped off by an IT
consultant before so am trying to learn as well.
Thanks,
Ian
Philippines
It will not be good practice to place huge pictures in BLOBs in sql server.if
possible you can arrange an file or image server and mapp them to application.
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
|||Thanks,
Do you know of any breaking points with SQL Server 2005 and WIndows Server
2003?
Ian
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
|||Why is it not good practive to place pics in BLOBs?
Thanks again,
Ian
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
|||As i posted earlier LARGE image file should not be loaded that is becuase
BLOBs store picture as text datatype u can find datatype in BOL .there will
be a severe impact on performance of database
"Ian" wrote:
[vbcol=seagreen]
> Why is it not good practive to place pics in BLOBs?
> Thanks again,
> Ian
> "Khwaja Arshaduddin" wrote:
|||> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
No , SQL Server stores it in BINARY format
"Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...[vbcol=seagreen]
> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
> "Ian" wrote:
|||Hi
You may want to read
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
As far as breaking point this is will be significntly dependent on the
hardware and application, therefore running your own performance/stress tests
is about the only way you are really going to have some idea of what the
system is capable of. Products such as LoadRunner, Rational Performance
Tester, Visual Studio Team Edition for Software Testers
http://msdn2.microsoft.com/en-us/teamsystem/aa718823.aspx or Visual Studio
Team Suite can all help you performance test your web application(s).
John
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
|||yes uri is correct it is binary... thanks uri
"Uri Dimant" wrote:

> No , SQL Server stores it in BINARY format
>
>
> "Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
> message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
>
>
|||At my last job, we used the database to store tif images. The tifs were
images of mandates which had bank details on so it made sense to store them
in the database as opposed to the filesystem. We took steps to try and ensure
the best performance, such as putting the blob column into a seperate
filegroup which we put onto a seperate raid array to the main database. The
mandates were scanned in as tifs, inserted into the db, and were viewable
from an asp front end, and tbh the solution worked well.
From a performance pov it'll be down to the quality of product, and the spec
of the machine.. ..a decent storage solution for this is a must.. ..also
spend some time on capacity planning, you'll find the db will grow quickly so
spend some time setting it up properly from the start...
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
|||Ian:
You'll love my response. It's the same as pretty much all of my other
responses:
"It depends".
Do you need to store your images transactionally? That is, it
critically important that your images are there when the database SAYS
they're there? If so, put 'em in the database.
Do you need to read the files from something like a Web server which
serves up a lot of other static content? If so, lean towards the
filesystem.
How big are these files? "Huge" means something very different these
days vs. 5 years ago. What are your size projections? A couple of
gigs? No problem, either way. A couple of terabytes? Do you want to
minimize the load on the database when retrieving images? How many
users are you going to support? These are all considerations.
Note that you'll have to be much more careful about how you size your
database files with the images inside the DB. I'd (sometimes, it
depends) recommend putting the tables storing the images in a different
filegroup...
Also note that in SQL Server 2005, you should use VARBINARY(MAX) instead
of IMAGE. IMAGE and TEXT datatypes are deprecated as of the new version.
-Dave
Ian wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
-Dave Markle
http://www.markleconsulting.com/blog

Breaking Point

Hi,
We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
2003 (Standard Ed, 32bit) for our company.
I would like to know the breaking point of the following so we can foresee
any problems and perhaps be able to avoid them.
There will be a huge amount of pictures to be stored in our server. Where
will pics be stored? as BLOBS in SQL or as files?
I am new to this and appreciate any info. We have been ripped off by an IT
consultant before so am trying to learn as well.
Thanks,
Ian
PhilippinesIt will not be good practice to place huge pictures in BLOBs in sql server.i
f
possible you can arrange an file or image server and mapp them to applicatio
n.
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||If you can, place pictures in filesystem and links to them in database.
MC
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:DC7B1026-6DB6-493A-9B99-8CF719840007@.microsoft.com...
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||Thanks,
Do you know of any breaking points with SQL Server 2005 and WIndows Server
2003?
Ian
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> It will not be good practice to place huge pictures in BLOBs in sql server
.if
> possible you can arrange an file or image server and mapp them to applicat
ion.
>
> "Ian" wrote:
>|||Why is it not good practive to place pics in BLOBs?
Thanks again,
Ian
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> It will not be good practice to place huge pictures in BLOBs in sql server
.if
> possible you can arrange an file or image server and mapp them to applicat
ion.
>
> "Ian" wrote:
>|||As i posted earlier LARGE image file should not be loaded that is becuase
BLOBs store picture as text datatype u can find datatype in BOL .there will
be a severe impact on performance of database
"Ian" wrote:
[vbcol=seagreen]
> Why is it not good practive to place pics in BLOBs?
> Thanks again,
> Ian
> "Khwaja Arshaduddin" wrote:
>|||> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
No , SQL Server stores it in BINARY format
"Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...[vbcol=seagreen]
> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
> "Ian" wrote:
>|||Hi
You may want to read
http://databases.aspfaq.com/databas...filesystem.html
As far as breaking point this is will be significntly dependent on the
hardware and application, therefore running your own performance/stress test
s
is about the only way you are really going to have some idea of what the
system is capable of. Products such as LoadRunner, Rational Performance
Tester, Visual Studio Team Edition for Software Testers
http://msdn2.microsoft.com/en-us/te...m/aa718823.aspx or Visual Studio
Team Suite can all help you performance test your web application(s).
John
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||yes uri is correct it is binary... thanks uri
"Uri Dimant" wrote:

> No , SQL Server stores it in BINARY format
>
>
> "Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote i
n
> message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
>
>|||At my last job, we used the database to store tif images. The tifs were
images of mandates which had bank details on so it made sense to store them
in the database as opposed to the filesystem. We took steps to try and ensur
e
the best performance, such as putting the blob column into a seperate
filegroup which we put onto a seperate raid array to the main database. The
mandates were scanned in as tifs, inserted into the db, and were viewable
from an asp front end, and tbh the solution worked well.
From a performance pov it'll be down to the quality of product, and the spec
of the machine.. ..a decent storage solution for this is a must.. ..also
spend some time on capacity planning, you'll find the db will grow quickly s
o
spend some time setting it up properly from the start...
"Ian" wrote:

> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>

Breaking Point

Hi,
We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
2003 (Standard Ed, 32bit) for our company.
I would like to know the breaking point of the following so we can foresee
any problems and perhaps be able to avoid them.
There will be a huge amount of pictures to be stored in our server. Where
will pics be stored? as BLOBS in SQL or as files?
I am new to this and appreciate any info. We have been ripped off by an IT
consultant before so am trying to learn as well.
Thanks,
Ian
PhilippinesIt will not be good practice to place huge pictures in BLOBs in sql server.if
possible you can arrange an file or image server and mapp them to application.
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||If you can, place pictures in filesystem and links to them in database.
MC
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:DC7B1026-6DB6-493A-9B99-8CF719840007@.microsoft.com...
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||Thanks,
Do you know of any breaking points with SQL Server 2005 and WIndows Server
2003?
Ian
"Khwaja Arshaduddin" wrote:
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
> > Hi,
> >
> > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > 2003 (Standard Ed, 32bit) for our company.
> > I would like to know the breaking point of the following so we can foresee
> > any problems and perhaps be able to avoid them.
> >
> > There will be a huge amount of pictures to be stored in our server. Where
> > will pics be stored? as BLOBS in SQL or as files?
> >
> > I am new to this and appreciate any info. We have been ripped off by an IT
> > consultant before so am trying to learn as well.
> >
> > Thanks,
> >
> > Ian
> > Philippines
> >|||Why is it not good practive to place pics in BLOBs?
Thanks again,
Ian
"Khwaja Arshaduddin" wrote:
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
> > Hi,
> >
> > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > 2003 (Standard Ed, 32bit) for our company.
> > I would like to know the breaking point of the following so we can foresee
> > any problems and perhaps be able to avoid them.
> >
> > There will be a huge amount of pictures to be stored in our server. Where
> > will pics be stored? as BLOBS in SQL or as files?
> >
> > I am new to this and appreciate any info. We have been ripped off by an IT
> > consultant before so am trying to learn as well.
> >
> > Thanks,
> >
> > Ian
> > Philippines
> >|||As i posted earlier LARGE image file should not be loaded that is becuase
BLOBs store picture as text datatype u can find datatype in BOL .there will
be a severe impact on performance of database
"Ian" wrote:
> Why is it not good practive to place pics in BLOBs?
> Thanks again,
> Ian
> "Khwaja Arshaduddin" wrote:
> > It will not be good practice to place huge pictures in BLOBs in sql server.if
> > possible you can arrange an file or image server and mapp them to application.
> >
> >
> > "Ian" wrote:
> >
> > > Hi,
> > >
> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > > 2003 (Standard Ed, 32bit) for our company.
> > > I would like to know the breaking point of the following so we can foresee
> > > any problems and perhaps be able to avoid them.
> > >
> > > There will be a huge amount of pictures to be stored in our server. Where
> > > will pics be stored? as BLOBS in SQL or as files?
> > >
> > > I am new to this and appreciate any info. We have been ripped off by an IT
> > > consultant before so am trying to learn as well.
> > >
> > > Thanks,
> > >
> > > Ian
> > > Philippines
> > >|||> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
No , SQL Server stores it in BINARY format
"Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
> "Ian" wrote:
>> Why is it not good practive to place pics in BLOBs?
>> Thanks again,
>> Ian
>> "Khwaja Arshaduddin" wrote:
>> > It will not be good practice to place huge pictures in BLOBs in sql
>> > server.if
>> > possible you can arrange an file or image server and mapp them to
>> > application.
>> >
>> >
>> > "Ian" wrote:
>> >
>> > > Hi,
>> > >
>> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS
>> > > Server
>> > > 2003 (Standard Ed, 32bit) for our company.
>> > > I would like to know the breaking point of the following so we can
>> > > foresee
>> > > any problems and perhaps be able to avoid them.
>> > >
>> > > There will be a huge amount of pictures to be stored in our server.
>> > > Where
>> > > will pics be stored? as BLOBS in SQL or as files?
>> > >
>> > > I am new to this and appreciate any info. We have been ripped off by
>> > > an IT
>> > > consultant before so am trying to learn as well.
>> > >
>> > > Thanks,
>> > >
>> > > Ian
>> > > Philippines
>> > >|||Hi
You may want to read
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
As far as breaking point this is will be significntly dependent on the
hardware and application, therefore running your own performance/stress tests
is about the only way you are really going to have some idea of what the
system is capable of. Products such as LoadRunner, Rational Performance
Tester, Visual Studio Team Edition for Software Testers
http://msdn2.microsoft.com/en-us/teamsystem/aa718823.aspx or Visual Studio
Team Suite can all help you performance test your web application(s).
John
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||yes uri is correct it is binary... thanks uri
"Uri Dimant" wrote:
> > As i posted earlier LARGE image file should not be loaded that is becuase
> > BLOBs store picture as text datatype u can find datatype in BOL .there
> > will
> > be a severe impact on performance of database
> No , SQL Server stores it in BINARY format
>
>
> "Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
> message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
> > As i posted earlier LARGE image file should not be loaded that is becuase
> > BLOBs store picture as text datatype u can find datatype in BOL .there
> > will
> > be a severe impact on performance of database
> >
> > "Ian" wrote:
> >
> >> Why is it not good practive to place pics in BLOBs?
> >>
> >> Thanks again,
> >>
> >> Ian
> >>
> >> "Khwaja Arshaduddin" wrote:
> >>
> >> > It will not be good practice to place huge pictures in BLOBs in sql
> >> > server.if
> >> > possible you can arrange an file or image server and mapp them to
> >> > application.
> >> >
> >> >
> >> > "Ian" wrote:
> >> >
> >> > > Hi,
> >> > >
> >> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS
> >> > > Server
> >> > > 2003 (Standard Ed, 32bit) for our company.
> >> > > I would like to know the breaking point of the following so we can
> >> > > foresee
> >> > > any problems and perhaps be able to avoid them.
> >> > >
> >> > > There will be a huge amount of pictures to be stored in our server.
> >> > > Where
> >> > > will pics be stored? as BLOBS in SQL or as files?
> >> > >
> >> > > I am new to this and appreciate any info. We have been ripped off by
> >> > > an IT
> >> > > consultant before so am trying to learn as well.
> >> > >
> >> > > Thanks,
> >> > >
> >> > > Ian
> >> > > Philippines
> >> > >
>
>|||At my last job, we used the database to store tif images. The tifs were
images of mandates which had bank details on so it made sense to store them
in the database as opposed to the filesystem. We took steps to try and ensure
the best performance, such as putting the blob column into a seperate
filegroup which we put onto a seperate raid array to the main database. The
mandates were scanned in as tifs, inserted into the db, and were viewable
from an asp front end, and tbh the solution worked well.
From a performance pov it'll be down to the quality of product, and the spec
of the machine.. ..a decent storage solution for this is a must.. ..also
spend some time on capacity planning, you'll find the db will grow quickly so
spend some time setting it up properly from the start...
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||Ian:
You'll love my response. It's the same as pretty much all of my other
responses:
"It depends".
Do you need to store your images transactionally? That is, it
critically important that your images are there when the database SAYS
they're there? If so, put 'em in the database.
Do you need to read the files from something like a Web server which
serves up a lot of other static content? If so, lean towards the
filesystem.
How big are these files? "Huge" means something very different these
days vs. 5 years ago. What are your size projections? A couple of
gigs? No problem, either way. A couple of terabytes? Do you want to
minimize the load on the database when retrieving images? How many
users are you going to support? These are all considerations.
Note that you'll have to be much more careful about how you size your
database files with the images inside the DB. I'd (sometimes, it
depends) recommend putting the tables storing the images in a different
filegroup...
Also note that in SQL Server 2005, you should use VARBINARY(MAX) instead
of IMAGE. IMAGE and TEXT datatypes are deprecated as of the new version.
-Dave
Ian wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
-Dave Markle
http://www.markleconsulting.com/blog

bpasetup install interruption?

Hi- My basic bpasetup install is not completing on Win2000 Advanced Server SP4/SQL Server 2000.
I get to the point where I enter my servername and authentication mode. I have tried my server name and my servername\instance name in both security modes. Nothing seems to compete the installation (the message says it is interrupted and to restart the
install).
How can I get it to complete? I have disabled McAffee as well but left up all SQL services.
Thanks!
Susan
Can you please generate an installation log and post it here or send it to
me?
To generate the verbose log run:
msiexec.exe /i BPASETUP.msi /L*v .\bpainstall.log
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Susan" <Susan@.discussions.microsoft.com> wrote in message
news:8C94F4F9-05A7-48E6-8296-FEC352D17EF3@.microsoft.com...
> Hi- My basic bpasetup install is not completing on Win2000 Advanced Server
SP4/SQL Server 2000.
> I get to the point where I enter my servername and authentication mode. I
have tried my server name and my servername\instance name in both security
modes. Nothing seems to compete the installation (the message says it is
interrupted and to restart the install).
> How can I get it to complete? I have disabled McAffee as well but left up
all SQL services.
> Thanks!
|||Christian- I emailed you the log but the post here has a limit of 30000 text (the log isdouble). Please email me if you haven't received or a preferred area where I can post/ftp the log to you. Thanks- Susan
Thanks!