Images And SQL 2000

Hello,
I'm looking to add imaging to an insurance application that was written in
house. We are programming in .Net with SQL2000 as the back end. The images
will be on average 50K and need to be stored for 7 years. Users will need
to retrieve these images from a web client to make underwriting decisions.
I was leaning towards storing the image in the data base, but while
researching the project the examples I've seen on the market all use a path
to a location to reference the image. This makes me think they either they
have found some issue with store large amounts of data in the data base or
they developed so early they the support of storing images in databases wasn
't there.
Our current SQL data base is 30Gig and the Image store we have is 275 Gigs.
I was hoping to get your opinion on the pluses and minuses of storing images
in a SQL data base.
Thanks in Advance,
MarkIn article <uyaJvCNmDHA.2652@.TK2MSFTNGP09.phx.gbl>, mark@.getamco.com
said...
> I'm looking to add imaging to an insurance application that was written in
> house. We are programming in .Net with SQL2000 as the back end. The images
> will be on average 50K and need to be stored for 7 years. Users will need
> to retrieve these images from a web client to make underwriting decisions.
> I was leaning towards storing the image in the data base, but while
> researching the project the examples I've seen on the market all use a path
> to a location to reference the image. This makes me think they either they
> have found some issue with store large amounts of data in the data base or
> they developed so early they the support of storing images in databases wasn
> 't there.
> Our current SQL data base is 30Gig and the Image store we have is 275 Gigs.
> I was hoping to get your opinion on the pluses and minuses of storing images
> in a SQL data base.
The pluses are that you have everything in one place for backup and
storage. The minuses are that you have everything in one place.
I find that I can use much cheaper storage for files than I use for my
database as a whole and I can easily add new volumes when I need to grow.
For some it's easier to just use the database for everything. In my
situation I have about 14 terabytes of image data in about 70 million
files driven by 35GB database.|||i read someplace that if you store images in SQL the front end must compose
the images from binary, send the images to SQL which in turn convert the
images into binary again to keep it in the tables => over head?
i am also in insurance business, don't see such apps using SQL to store
actual images. Hard drive being cheap ins't a reason I would save images in
SQL.
"Mark" <mark@.getamco.com> wrote in message
news:uyaJvCNmDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I'm looking to add imaging to an insurance application that was written in
> house. We are programming in .Net with SQL2000 as the back end. The
images
> will be on average 50K and need to be stored for 7 years. Users will need
> to retrieve these images from a web client to make underwriting decisions.
>
>
> I was leaning towards storing the image in the data base, but while
> researching the project the examples I've seen on the market all use a
path
> to a location to reference the image. This makes me think they either
they
> have found some issue with store large amounts of data in the data base or
> they developed so early they the support of storing images in databases
wasn
> 't there.
>
> Our current SQL data base is 30Gig and the Image store we have is 275
Gigs.
>
> I was hoping to get your opinion on the pluses and minuses of storing
images
> in a SQL data base.
>
> Thanks in Advance,
> Mark
>

iif stored procedure

Hi all,

I have a bunch of queries initially written for MS Access that contain iif
function.
Since I'm new in SQL Server and I don't like the idea of rewriting all
queries using CASE statement, I hope someone has written iif T-SQL stored
procedure.
If someone have T-SQL code of such procedure I would appreciate you post
this code here.

Thanks in advance!"Anabella" <x@.x.com> wrote in message news:cu86s9$pj0$1@.ls219.htnet.hr...
> Hi all,
> I have a bunch of queries initially written for MS Access that contain iif
> function.
> Since I'm new in SQL Server and I don't like the idea of rewriting all
> queries using CASE statement, I hope someone has written iif T-SQL stored
> procedure.
> If someone have T-SQL code of such procedure I would appreciate you post
> this code here.
> Thanks in advance!

Since IIF doesn't exist in TSQL, I don't think you have any other option.
The Upsizing Wizard might help, but the most reliable thing to do would be
to rewrite them.

Simon|||"Anabella" <x@.x.com> wrote in message news:cu86s9$pj0$1@.ls219.htnet.hr...
> Hi all,
> I have a bunch of queries initially written for MS Access that contain iif
> function.
> Since I'm new in SQL Server and I don't like the idea of rewriting all
> queries using CASE statement, I hope someone has written iif T-SQL stored
> procedure.
> If someone have T-SQL code of such procedure I would appreciate you post
> this code here.
> Thanks in advance!

I think maybe you could write a udf which took parameters.
I think handling the various comparisons might be hard work.
Off the top of my head, I think you'd have to change the syntax of your
query a bit so you handed the comparison as a parameter.
And... erm... changing your query is what you wanted to avoid.

I've got some other bad news for you as well.

MS Access sql is slightly different from sql server sql .
I would suggest you need to go through all your queries and check em out.
Changing iif to case statements is likely just part of the task you face.

--
Regards,
Andy O'Neill|||Andy O'Neill (aon14nocannedmeat@.lycos.co.uk) writes:
> I think maybe you could write a udf which took parameters.
> I think handling the various comparisons might be hard work.
> Off the top of my head, I think you'd have to change the syntax of your
> query a bit so you handed the comparison as a parameter.
> And... erm... changing your query is what you wanted to avoid.

Since boolean is not a datatype in SQL Server, you cannot write a
UDF which permits you to say:

SECECT dho.iif(@.x = @.y, 1, 2)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns95F7EFAAF416CYazorman@.127.0.0.1...
> Andy O'Neill (aon14nocannedmeat@.lycos.co.uk) writes:
>> I think maybe you could write a udf which took parameters.
>> I think handling the various comparisons might be hard work.
>> Off the top of my head, I think you'd have to change the syntax of your
>> query a bit so you handed the comparison as a parameter.
>> And... erm... changing your query is what you wanted to avoid.
> Since boolean is not a datatype in SQL Server, you cannot write a
> UDF which permits you to say:
> SECECT dho.iif(@.x = @.y, 1, 2)

I had in mind handing over the comparison operation as a string.
So check if the comparison to be made is varchar and '=' or maybe '>' or
'<'.
If that makes sense.

That's the part I'm actually most confident I could handle.
I didn't even begin to think about the various datatypes one could have for
other parameters...

--
Regards,
Andy O'Neill

iif inside iif

I'd error message on this expression ,

It is written in hidden property of an image

Can you help me to correct it?

thanks all.

=iif(Parameters!Direction.Value = "none", True, iif(Parameters!Direction.Value = "Ascending",True,False )

You are missing a closing ")" and when comparing strings I would use the "equals" method.

Here is what the statement should be:

=iif(Parameters!Direction.Value.equals("none"), True, iif(Parameters!Direction.Value.equals("Ascending"),True,False ))