Thanks Ninga...

By the way, I'm waiting for an access to let you look at the problem on my server. I already ask for your help, by email, and told you...

Thanks Kevin!

Sorry for my ignorance...

How do I do a file IO stall analysis? What IO stands for?

Thanks!

Hi!

Open your Microsoft SQL Server Management Studio, click New Query, and type your SQL request. In the Query menu, select the Include Actuel Execution Plan option, and then, Execute your...

Thanks!

That's what I'll do! I'll post the solution later to help others having the same issues.

You just lost me... ::crazy:

I know the basis of SQL, what you ask me to do is out of my knowledge. As I said, I found this SQL Request on...

Ok... I'm not sure what should I do?

You tell me what you did, but how I apply this to my problem? As I said, I'm not an SQL expert. I...

Hi!

By temp table, do you mean to create a similar table, with the same content, and...

Hi, thanks, I really appreciate your help.

I have problems with my laptop, I was not able to work on it for the past 2 days... I've to go to work...

Jack Corbett (4/12/2012)

---

Interesting that the added index was not used as it still did an CI Scan.

I have a couple more questions:

How many rows are in...

The problem is still there... But here the new execution plan:

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

...

I added the missing index... I'll see if this fixes the performance!

I'll keep you informed!

Thanks all for your help!

Sorry, I dont know all about SOUNDEX. Sounds complicated...

Thanks!

Here's the script again :

USE [cameleshop]

GO

/****** Object: Table [dbo].[RECHERCHE_CONTENU] Script Date: 04/09/2012 15:15:09 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[RECHERCHE_CONTENU](

[ID_SITE] [int] NULL,

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

[TITRE]...

How can I get the full_text index script?

As you can see, I’m not an SQL expert 😉

Here what I found about the "CREATE TO" script for RECHERCHE_CONTENU:

USE [cameleshop]

GO

/****** Object: Index [PK_RECHERCHE_CONTENU] Script Date:...