First thing I notice is that SQL Server is suggesting you create exactly the same index I mentioned earlier:

CREATE NONCLUSTERED INDEX nc1

ON dbo.Con_RecipientToMessages (Id)

INCLUDE...

Using a recursive CTE:

DECLARE @Sample

TABLE (

code CHAR(1) NOT NULL,

value...

Another solution I have used in the past is to monitor the size of the ad-hoc plan cache using a job based on:

SELECT [MB used] = SUM(single_pages_kb + multi_pages_kb)/1024.0

FROM...

Those are estimated plans.

Use a full-text index.

USE Test;

GO

CREATE TABLE dbo.Test

(

row_id INTEGER IDENTITY NOT NULL,

...

Is a trace running on the TEST server?

Zero :exclamation:

Not easy. One way is to show that the procedure cache is using too much...

Stage-by-stage breakdown:

--

-- *** STEP 1 ***

--

-- Get all the data for a particular product from the

-- history table and the current Products record

--

-- The columns are converted to SQL_VARIANT for...

Night Bob. That puts you somewhere like Chicago...CDT. Just after 6pm Friday here.

Should give Steve an idea for your 20,000 posts award.

GSquared (3/18/2010)

john.arnott (3/18/2010)

Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, ...

Several reasons, mostly consistency. I am registered with that name on other forum-type sites, and it matches my...

Powerful mental image there...

XML methods require that your session has SET QUOTED IDENTIFER ON.

Many features of SQL Server 2005 require specific settings (indexed views, for example).

Output to...