Storing Images in MSSQL 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Storing Images in MSSQL 2000

  1. #1
    Rudy Panigas Guest

    Storing Images in MSSQL 2000


    Hello,

    I understand that Microsoft is using SQL 2000 to run their TerraServer, which
    stores satelite images. Do you know if storing that actual image in the database
    is a good idea? Or should a link to a path of the stored images is better?
    How does Microsoft do it? We are trying to create a database which will house
    employees pictures and am getting conflicting information from just about
    everyone. One last question, do you know whom at Microsoft I could talk to
    and/or books I should buy?

    Thank you for your time and effort,

    Rudy Panigas
    Senior DBA and Network Analyst
    Guardian Capital Group Ltd.
    Toronto, Canada
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Storing Images in MSSQL 2000

    Hi Rudy,

    See my earlier post under "text, ntext, and image datatypes - worth using?"

    Basically, it's definitely done on some sights and is not without it's
    benefits. I'm not going to say that one or the other is better at this
    point - I would say that they both have their times to use them at this
    point. The trend, however, is towards going ahead and storing it in the
    database (reversing the previous trend).


    --
    Rob Vieira
    Visit www.ProfessionalSQL.com Today. It's new and improved!

    "Rudy Panigas" <rpanigas@guardianfunds.com> wrote in message
    news:3a6ede48$1@news.devx.com...
    >
    > Hello,
    >
    > I understand that Microsoft is using SQL 2000 to run their TerraServer,

    which
    > stores satelite images. Do you know if storing that actual image in the

    database
    > is a good idea? Or should a link to a path of the stored images is better?
    > How does Microsoft do it? We are trying to create a database which will

    house
    > employees pictures and am getting conflicting information from just about
    > everyone. One last question, do you know whom at Microsoft I could talk to
    > and/or books I should buy?
    >
    > Thank you for your time and effort,
    >
    > Rudy Panigas
    > Senior DBA and Network Analyst
    > Guardian Capital Group Ltd.
    > Toronto, Canada



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center