Re: Reclaiming diskspace after deleting rows

Tech-Archive recommends: Fix windows errors by optimizing your registry



I deleted about 20 million rows out of my DB that had about 200 million
rows.

Are we supposed to mindread which database you are talking about?
Oracle? SQL Server? Sybase? Access? Paradox? Dbase?

Stephen Howe


.



Relevant Pages

  • Re: Disk or network error
    ... You don't say of you can open the DBASE file from DBASE on the remote ... IV database to MS SQL Server database. ... I gave the user full rights but i am still getting this error message. ...
    (comp.databases.ms-sqlserver)
  • Proper table structure and SQL Server limits
    ... I am migrating a Paradox application to SQL Server. ... Field Data: ... Identifier | Attribute | Value ...
    (microsoft.public.sqlserver.server)
  • Re: Migrating SQLServer DBs to Sybase
    ... Server-generated scripts to create the structure in Sybase, and SQL Server ... AseConnection objCon = new AseConnection; ... objCon.ConnectionString = strConnectionString; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Proper table structure and SQL Server limits
    ... > I am migrating a Paradox application to SQL Server. ... Correcting it will mean a ... > limits are higher in SQL Server, it will eventually hit the wall. ... So the original design is the correct one. ...
    (microsoft.public.sqlserver.server)
  • Re: Scheduling DTS job
    ... If you try to transfer the same rowsfrom SQL Server to SQL Server ... > How do i see if there is any difference in the driver ... >>> The SQL server agent is running as Local System Account. ... >>> Nothing has been changed in sybase box. ...
    (microsoft.public.sqlserver.dts)