I'll check tomorrow, if someone hasn't got there first.

Per database.

Again, only really useful if you have IO problems and the file are going on separate physical drives

Why are you thinking 1 file per cpu per filegroup? What was...

Then try something like this:

select top 1000 * FROM

(SELECT lc.email

l.leadid,

...

TS stands for Technical Specialist. The 'entry level' certification.

SG (1/29/2009)

---

So I tried this but am still getting duplicates - why?

select top 1000 * from (

select

...

Can you post the queries, the table schemas, the index definitions and the execution plans with that table as part of the query? (save as a .sqlplan file, zip and...

No. Not at all. That recommendation is give for TempDB and only for TempDB and only if you're...

If it was a deadlock, you'd be getting a different error.

Msg 1205, Level 13, State 45, Line 5

Transaction (Process ID 53) was deadlocked on lock resources with another process and...

A deadlock won't cause a job to hang. It would cause a job to fail. Are you sure you're getting deadlocks, and not regular blocking?

ScottPletcher (1/29/2009)

---

I never said it was doing a seek, I said it was using the index. It looked to me like SQL was scanning the non-clus index to get...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic645895-145-1.aspx

What I'd suggest is, instead of sending the mail direct from a trigger (which is usually a bad idea anyway), have the trigger write the info for the mails into...

Please create a new thread for a new question, don't just tag on to the end of an existing thread.

In addition, this is a repeat of a post tagged onto...

Sounds like you're trying to restore over an existing database. If this is a migration from MSDE to SQL 2005, why are you restoring over an existing database? You should...

sudhirbharti (1/29/2009)

---

SELECT @user-id = userid,

@OldCity= d.City

FROM deleted d

SELECT @NewCity =...