I meant the output might help explain it to me! 😀

It didn't. I suppose your SQL Server team might have hacked sp_send_dbmail - the default procedure has an EXECUTE...

Peter,

Are you able to run:

select net_transport, protocol_type, auth_scheme from sys.dm_exec_connections where session_id = @@spid;

select [host_name], login_name, original_login_name from sys.dm_exec_sessions where session_id = @@spid;

...please?

The results may help explain things.

Paul

Books...

Sander A. (11/10/2009)

---

Edit: i have been thinking about it after i typed this message. And you might have a really good point here. With the right indexes this could make...

A full optimization will take a few minutes, but the main problem seems to be a missing index, something like:

CREATE UNIQUE NONCLUSTERED INDEX [UQ dbo.TransactionDetail TransactionId (AccountId, Direction, Amount)]

ON [dbo].[TransactionDetail]...

Nice quote G². There is a lot of over-excitement surrounding fragmentation. Maybe it's because people 'know' that it is important to keep disk files defragmented?

The situation in SQL...

Yes, the posted execution plan just shows the plan for:

DECLARE @ISLEAF BIT

SELECT @IsLeaf = IsLeafAccount FROM Account WHERE AccountNum = @AccountNum;

...which isn't really the performance-critical bit 😛

Please do take...

So the problem here was the usual sniffing/recompile thing. I just want to add that sometimes problems are genuinely caused by the statistics histograms not containing any entries to...

Oh absolutely - the discussions are probably what keeps me...

LMAO!!! :laugh:

Leading horses to water spings to...

Why does no-one ever include an actual execution plan? Actual row counts and thread distribution data are so important! And why omit the fact that the SQL is...

Some references for you:

Factors That Can Delay Log Truncation

sp_repldone

Hey Louis,

A wait description of 'REPLICATION' means that the log is being held active by transactional replication. The first thing to do is to check whether the database has...

I used Google. Found http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx which contains a script to do what you ask. The people in the thread seemed impressed with it.