Defragmentation of table

We are using database having a current size of over 300GB
to store attachment files in an image column of a table.
is the approach of exporting and importing data records
from the table a good way to defragment the table? if so,
is it possible to export the data records as a flat file
to a tape drive.
thanks.
There are commands in SQL Server to defrag and reorg. I strongly suggest you start by reading below
excellent whitepaper:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx.gbl...
> We are using database having a current size of over 300GB
> to store attachment files in an image column of a table.
> is the approach of exporting and importing data records
> from the table a good way to defragment the table? if so,
> is it possible to export the data records as a flat file
> to a tape drive.
> thanks.
>

Defragmentation of table

We are using database having a current size of over 300GB
to store attachment files in an image column of a table.
is the approach of exporting and importing data records
from the table a good way to defragment the table? if so,
is it possible to export the data records as a flat file
to a tape drive.
thanks.There are commands in SQL Server to defrag and reorg. I strongly suggest you
start by reading below
excellent whitepaper:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx
.gbl...
> We are using database having a current size of over 300GB
> to store attachment files in an image column of a table.
> is the approach of exporting and importing data records
> from the table a good way to defragment the table? if so,
> is it possible to export the data records as a flat file
> to a tape drive.
> thanks.
>

Defragmentation of table

We are using database having a current size of over 300GB
to store attachment files in an image column of a table.
is the approach of exporting and importing data records
from the table a good way to defragment the table? if so,
is it possible to export the data records as a flat file
to a tape drive.
thanks.There are commands in SQL Server to defrag and reorg. I strongly suggest you start by reading below
excellent whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx.gbl...
> We are using database having a current size of over 300GB
> to store attachment files in an image column of a table.
> is the approach of exporting and importing data records
> from the table a good way to defragment the table? if so,
> is it possible to export the data records as a flat file
> to a tape drive.
> thanks.
>

Default value for image column

HI All,
Does someone knows if it is possible to get a default value on a image column type!
Cheers WimHI All,

Does someone knows if it is possible to get a default value on a image column type!

Cheers Wim

I don't think so it will allow. Best way is to try adding a
default on the column. :D|||HI All,

Does someone knows if it is possible to get a default value on a image column type!

Cheers Wim

You must define the default value as a binary constant:

create table #l
(
[thing] image not null default( 0x0000000001 )
)|||You must define the default value as a binary constant:

create table #l
(
[thing] image not null default( 0x0000000001 )
)

Oops :rolleyes:|||Thanx for your reply,

How can i get my own image as a default?

Default value for a image

Hi, i would like to insert a default value for a image column in sql server express. is this possible?

I would like to do this so that when users pull up a record in my web forms there is something to see.
thanksyou can either do this from the backend or front end. in table design view you can set the default vale..from your front end you can check for null and show a default image instead.|||Don't store your images in the database. One main reason is the size of the db will grow quickly. It's almost always better to put them on the server's hard drive. In your database you can store the name of the image and call it that way. Setup a varch column of whatever length you need. To answer your default question...store a default image on the server, "myImage.gif" for example. Then insert this image name into your varchar column when you need the default value.|||::Don't store your images in the database. One main reason is the size of the db will grow
::quickly.

So what?

There are arguments in vfacvour and against storing images in the database, but this one is ridiculous.

You may not realize it, bit 1gb = 1gb. Whether I blow 1gb on a SQL Server database, or in the file syste, does not make a dime of a difference.

And then you ignore a lot of the problems you get yby your approach.

* How do you handle transactional guarantee that all images are deleted when they should be?
* How do you make a coherent backup of all material? Note the word "coherent" here.

What exactly is your problem with having a 2gb SQL database? You use shared hosting on a plan that does make a difference? Get a good host.