Is the TempdB on its own dedicated drive?

How you run Profiler to determine long running queries? Some of these queries may be using the tempDb especially if temp tables...

The RedGate backup will also validate the file.

Thanks for the value added comments. They're all worth appending into the article.

If you have an anti-virus installed, check the settings to make sure it's not blocking the application. You may need to add exceptions.

databasemail90.exe

DTExec.exe (SSIS)

dtexecui.exe

You should be able to see...

bkirk (5/31/2009)

---

Apart from turning off the foreign keys and running 2 delete statements inside a loop, i am looking for some guidance to keep the foreign key relationships and still...

...so the job is working, but... It's your query that's not inserting the expected results? There wouldn't be an "overwrite" for an INSERT statement. An "overwrite" would...

From TechNet

The Great Debates: Pass Phrases vs. Passwords. Part 1 of 3

The Great Debates: Pass Phrases vs. Passwords. Part 2 of 3

The Great Debates: Pass Phrases vs. Passwords....

Use PerfMon with the counter %DiskTime for the disks that your server is using. If this is greater than 20ms, then you need to look deeper into the disk.

Disk...

According to "Professional SQL Server 2005 Performance Tuning" published by...

Heads Up

Be aware of performance when using a "linked server". It's not very efficient, especially if you're running transactions, such as INSERT/UPDATE/DELETE, between the servers. If you are...

It might be faster?

If the databases are on different disks you might actually have better performance.

How does the query plan look? If the joins are using proper indices and...

Instead of relying on AUTOGROW,

consider running a script which runs weekly to provide you the size of the database and used extents/mb, along with percentage of datafile used. When...

I checked with an Indian working here and he indicated that "Database Administrator" is the proper title and is commonly used in India.

He indicated that the title is more important...

"DBA"

then describe the duties and focus.

You will be responsible for production monitoring as well as...

Must have experience with performance tuning and be able to mentor developers.

Steve

Risk Free?

Since the primary purpose of the cluster is for high availability with regards to hardware failures, uncommitted transactions would be rolled back; so I would do the following for...