Re: Delete from takes a very, very long time

From: Steve Kass (skass_at_drew.edu)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 00:13:17 -0500

Joe,

  This thread is now very long, but you have yet to post
the actual query and table structures. Correct me if I'm wrong,
but I assume your table is not named mytable and your column
is not named mycol. Could you please post the actual
CREATE TABLE script for this table and any indexes or
constraints on it, along with the actual query
that is so slow, all cut and pasted into your post?

It would also help to see the CREATE statements for any
dependent objects, such as other tables with foreign key
constraints that reference this table or indexed views based
on this table.

The query plan for the DELETE query would also be
very useful to see, as would the result of running the
query after executing
SET STATISTICS IO ON

SK

Joe wrote:

>CONSTRAINT [PK_research] PRIMARY KEY CLUSTERED
>
>This is from the create script.
>
>Could it matter that I added 5 - 7 million records in one section and
>removed them in another 10-12 times?
>
>"pdxJaxon" <GregoryAJackson@Hotmail.com> wrote in message
>news:OJbA#d8EFHA.3672@TK2MSFTNGP14.phx.gbl...
>
>
>>I dont think this table has a clustered index on it
>>
>>the Scan Density doesnt make sense
>>
>>
>>GAJ
>>
>>
>>
>>
>
>
>
>

Relevant Pages

  • Re: HELP! Need AD Query for Last login
    ... query the DCs in the USA domain, how would I modify the script? ... I'm new to VB script and making this simple modification is beyond me at ... >> ' Because the lastLogon attribute is not replicated, ... Then, for each Domain Controller, ADO is used to search the ...
    (microsoft.public.scripting.vbscript)
  • Re: LDAP query information
    ... a "Dim" statement. ... script is run. ... Microsoft MVP Scripting and ADSI ... Can you please provide me info on what to do with the below query? ...
    (microsoft.public.windows.server.scripting)
  • Re: LDAP query information
    ... execution of the vbscript? ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)
  • Re: An application, script, or AD Saved query that ...
    ... It is a multi-step operation as you can't create a query that says give me all users who aren't in a mail enabled group. ... So the most efficient way I can visualize this is that your script will need to find all members of all mailenabled groups. ... This you will enumerate the members and stick them in a hash/dictionary/whatever it is called in the scripting language you use, basically you want an associative array. ...
    (microsoft.public.windows.server.active_directory)
  • Re: LDAP query information
    ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... Set adoConnection = CreateObject ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)