As a follow up - I know it's weeks after the original, but I did what Grant suggested and it seems that param sniffing was killing the query. Happy,...

Thanks Grant, I'll search for that and see what I come up with.

Very much appreciate the reply...

Paul Randal (11/14/2007)

---

I'm intrigued - can you post the T-SQL you're using? I'm not a stats expert but I can probably get Kimberly to take a look.

Yes, if you're doing...

Paul,

Thank you so much for your replies - I hadn't anticipated having the author of CHECKDB answering!

I was able to set up a copy of the DB in a safe...

You want to use SET ROWCOUNT @top before your query and SET ROWCOUNT 0 afterwards.

DECLARE @top int

SET @top = 100

SET ROWCOUNT @top

SELECT policynumbers FROM tblpolicynumbers

SET ROWCOUNT 0

Peter and Ramesh - thank you so much for such prompt replies, the SQL gods are obviously smiling on me today! 😀 I'm fairly new to SQL 2005...

I've also just realised that I'm working in SQL Server 2005 for this database, not SQL server 2000 (which I normally have to work in). Dang - this should...

I've been thinking more about this - what if AValue is NULL or not-unique between differing values of NonUniqueID? Then I would be joining up on totally incorrect rows....

Thanks Herve for the extra pointers. This is all really useful and helpful to know - it's just good to get a better understanding of what is available for...

Ramesh - thank you, that is exactly what I wanted! Many thanks - I've not come across CROSS JOIN before :unsure: - I'd always assumed that there was a...

Steve Jones - Editor (10/11/2007)

---

Only if the client sends it in. the hostname is usually in sysprocesses (sp_who2) when the person connects, but I'm not aware of a way to...

Thanks for the reply - the information is so useful.  We have only recently been able to start tightening up our notifications from SQL servers and it is really helpful...

Thanks for the link - I will look that up.

One more request for advice - I am looking to set up e-mail for another SQL Server (same set up as...

That was it!  I opened Outlook and all the DTS "Send Mail Task" attempts I'd been trying suddenly came through.  Thank you, both lucky and loobyloo for the replies!

I've got...

Right, I've looked at the error log file and there's no indication that the SendMailTask failed:

Step 'DTSStep_DTSSendMailTask_1' succeeded
Step Execution Started: 21/12/2006 09:34:22
Step Execution Completed: 21/12/2006 09:34:23
Total Step Execution Time: 0.532...