[dba-SQLServer] Can't drop the PK from a table

I guess it's the tempdb filling your disk. Did you check the size of tempdb
to see if she's the culprit?

It strikes me that your process inserting 1300 rows every 10 minutes maybe
doesn't leave a window wide enough for SQL Server to apply the index
rebuild-values from tempdb, which would then grow beyond acceptable size.

To get tempdb back to normal size you could restart SQL Server, which will
recreate this database.

Is it viable for you to temporarily disable the process or expand the
interval between the processes? In that case you should be able to run the
REBUILD INDEX without the online option, supposing of course no other
processes are blocking the index.

Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur
Fuller
Sendt: 19. juni 2008 11:19
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] Can't drop the PK from a table

I ran out of disk space, which is hilarious. I bought this new notebook less
than a month ago and it's got a 100 GB drive, and I'm already out of disk
space. Time to look at one of those USB drives. I've never played with one
before but I see that they come in sizes up to a TB. My gut feeling is that
they have to be a lot slower than a normal hard disk.

Can anyone who has one of these respond with even vague comparisons of
speed?

A.

On Wed, Jun 18, 2008 at 4:15 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> Hi Arthur
> Did it work out?
>
> Asger
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com