Looks to me like a problem with security, have a look at the account in which SQL agent starts with, if you are on a domain try using a dedicated...

Hi Guys,

Thanks for the info, I will have a word with stakeholders and formulate my index strategy.

thanks,

Usual culprits are as follows:

1. Check recycle bin and empty it if you dont need to restore anything back.
2. Shrink your database, not a good thing, but might be a last option,...

Thanks for geting back to me, I cannot read the website you posted as its not in English.

Anyone know any other tool

Thanks for your reply guys, the cost of rebuilding the indexes is quite high, the table itself contains medical records and contains around 200m rows.

Also, when doing a report that...

Thanks guys, I will examine the requirements closely again, can anyone recomend any good book/resource in mastering reporting services.

Thanks

The 2 of them do nearly thesame thing, what you will need to think of is your enviroment and which one suits best:

To Summarise

Dbreindex: Faster but causes blocking, and you...

What I have also noticed is that if you have a clustered index on the date column, the execution plan woulkd be ideal, i.e might do a clustered index delete.

thanks all for the reply, the SAN will be primarily for storage, but these days you cant seem to get Storage and Performance, there has to be a trade off,...

Hi

I ran  a test using one of the code displayed above, but I was inserting into a table using rowcount, and it just kept inserting over and over again without...

Have you got the latest Service Packs on Sql 2005, as I have ran into problems before because of not having the latest service packs, do a simple windows update...

Thanks for your post Mike, I do agree with you on the issue of hardware, I also forgot to mention, there are no foreign keys being referenced by this table.

Lastly,...

Hi All,

I done as above, i.e delete in 25k batches, and it was still taking ages to delete around 30m records out of a table with 300m records.

The delete is...

thanks all for your answers.

I have a problem, I have a table which has an identity column, and I want to do batched updates, i.e update row 1 - 50,...

Hi

Yes it does, thesame account is used for SQL server user SA and Bulk insert works.

what amazes me is why it doesnt work for windows authentication with SA rights.

It works...