This just started to happen to us, exact same user failing when trying to send directly calling sp_send_dbmail, not via a sproc.

1. Did you ever work out what caused it?

...

Assuming you have an index on NormalizedUserName...

I'd use something like this:

DECLARE @UserName VARCHAR(1000);

DECLARE @PasswordHash VARCHAR(1000);

SELECT TOP 1 * FROM

(

SELECT U.UserName, CASE WHEN U.EmailConfirmed = 1 THEN 1 ELSE -2 END...

Dammit, I got all excited there until I realised it was an Enterprise feature.

How about an index on ServerId ASC, DateCreated DESC

Again, just another punt, I don't have ssms to try it out.

Have you tried

WHERE ServerId IN (1,2,3,4)

in the group by query just to see if it makes a difference?

It probably wont but worth a try 🙂

Out of sheer curiosity, did you try the reversed where clause with distinct?

It sounds to me that they are refering to the fact that you can write code that applies both an in-row varchar and the max LOB type. As opposed to...

Guys, i'm by no means playing the same sport let alone be in the same league as jeff and grant but from the the op's query he does seem to...

It does look like the parameters are just getting their lengths from the lengths of the strings that are assigned to them instead of getting set a predefined size.

i'm not...

No worries, glad it helped 🙂

Hi,

I'm not sure if there is a better way but you could try:

SELECT CEILING(251.438246 * 10000) / 10000

All it does is get the 4 decimal places into the int portion.

You...

Paul White NZ (9/20/2010)

I wish it were that simple 🙂

Brad's query example is not a nice one for the optimizer: the input is a variable (obviously no stats on a...

@howard - thanks for replying so quickly.

Sorry, that was pretty rude.

Had a bit of a busy day, I didn't intend on posting and then ignoring the thread....

Anyone else a little concerned about the 2k8 results for the inline Tally?

Sorry, I would obviously try this myself but I don't have a 2k8 instance to hand, could someone...

Just a thought but does anyone know if using Deleted bits instead of actually deleting help with the stats and index fragmentation?