If you are selecting and deleting by a date range, maybe you could create a
clustered index on your date colum.
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:>You do not mention if you are deleting one row, a range, or the entire
Deleting a date range (1 out of 3 days log actually)
Quote:>Your question on select statements: Do you query all data, or do you pass
>some criteria to it?
Select by date range
Quote:>If you are passing criteria, do you have the proper indexes on the table?
Quote:>What happens when you query the table from Query Analyzer? Same (slow)
Everything else which tries to query the server times out or lock up (e.g.
Quote:>Is your server a dedicated SQL box, or are you running IIS on it to? I
>because I wonder how much memory/cpu/disk SQL Server is able to use during
>the actions (delete and select).
It's a dedicated SQL box. No memory limit set on the SQL Server.
select or delete statement is not as much an issue as the website or other
programs not being serviced.