Thanks for the response Suresh

Let me clear out the mismatch of words, I want to move the system database from one drive to another, the MASTER db was moved with...

If you can provide the following info it will help to better understand the situation that you have encountered

-Table definitions

-The size of the tables (number of rows)

-The usage of...

•Reo; may I ask why, you don’t want sql to decide on the parallelism? What is you final objective ?

•I know that a query can be limited to use...

As sql server re-uses the same execution plan, its highly unlikely you will be able to capture what you intend.

I would advice you to read this article from Kimberly...

As sql server re-uses the same execution plan, its highly unlikely you will be able to capture what you intend.

I would advice you to read this article from Kimberly...

I am not very clear on what is meant as a dedicated job scheduler but my general understanding is that sql server will assign a thread from the thread pool...

I was considering locking/blocking and availability of the table

Just few things to consider:

When deleting data probably for archiving from VLTB’s, delete data based on the PK of the table and not on the FK.

Rebuild the index subsequently.

Some questions

-Do you use link servers and join with many tables between database?

-Have you got sql R2 on the server ?

-What time are the index rebuilds jobs happening...

Thanks for the extra information

I’m not a great fan of triggers 🙂 , I’d suggest to schedule a job and send the email as part of the job.

There will...

Hi Erik

I know you are not blocked any more with request but can you please elaborate on why you want to do this?

Can you also please answer...

I generally create the query dynamically and execute IT there after

Use DBName

SELECT 'GRANT EXECUTE ON <OBJECTNAME > TO ' + NAME FROM SYSUSERS

Hope this helps

Hi T2512

I have done a small script that will help you get started. This script deletes the duplicate records in one go. Just a word of caution,...

Can’t you request for a common standard for the text , csv file? If you can initiate this SSIS is the way forward

I’m not sure what to tell you man. Every day is going to be a bad day in office with the setup you got there.

Need to agree with Jeff...