I wondered about that but wouldn't...

The annoying thing is that at the time of posting on this forum the query runs in less than a second, it's only at certain periods throughout the day when...

Grant Fritchey (3/18/2009)

---

First, just a word of caution, NOLOCK can lead to bad data. I don't just mean the ubiquitous "dirty read" meaning uncommitted changes, but I mean, extra rows,...

HI

I've attached the execution plan

Sure, here's the query:-

WITH myMessages AS (

SELECT msg.id, msg.m_username, msg.c_name, msg.m_Created, msg.m_subject, msg.c_msg, msg.m_read, msg.m_dateRead, msg.m_replied, msg.m_dateReplied, msg.m_forward, msg.importance

,ROW_NUMBER() OVER (ORDER BY msg.m_read asc,

case

when @order=1 then...

Okay here goes, this is the table structure and the indexes

-- Table Structure

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[msg](

[id] [int] IDENTITY(1,1) NOT NULL,

[c_name] [nvarchar](100) NULL,

[c_mail] [nvarchar](150) NULL,

[c_company] [nvarchar](150)...