Thanks for the reply. Yes, ORM, in this case, meant Object Relational Mapping.

We are talking about new projects and new databases. Although actually, we've had databases and projects running, but...

Nice. Much better, and I'm sure it performs a lot better.

Or, you can have a procedure call itself. That too is recursion. Triggers can call themselves too. That's usually referred to as "an error."

😀

Check your structure. I created a structure like this:

CREATE TABLE dbo.FileName

(

tipcon INT

,data DATETIME

,field1...

Johann Montfort (4/15/2008)

---

Dear All,

I have a complex stored proc, which I inherited from the previous developer, and I wish to fine tune it a bit, because its taking 1.36 mins...

Mahesh Bote (4/15/2008)

---

[font="Verdana"]Johann, look at the below SProc, I tried to update.

ALTER PROCEDURE [dbo].[sp_getpageidsforedb]

@projectid int

AS

Set Nocount On

Begin

create table #ebdindex (

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

[stringid]...

First, having an index on a table won't slow down reads of that table assuming the reads use a different index. Second, get an execution plan for the query and...

Quick & dirty, this will run your proc on all databases within a given instance:

sp_msforeachdb 'use ?;select schema_name(schema_id)as ObjectName, name,type,type_desc from sys.objects

where schema_name(schema_id) <> ''dbo''

and type in(''U'',''P'',''V'', ''FN'',''TF'',''IF'',''K'',''UQ'')'

However, to gather...

So you want to udpate data based on the name of a column? Is that right?

To get started, you might want to look at some of the links off the Database Professional Team Center. Specifically, I'd look at the introductory web casts near the bottom...

OK.

They're in there. I'm so used to 2005 (you are posting in a 2005 forum, by the way) that I thought you'd see them. You won't. Here's the answer...

Just out of curiousity, was it an index scan with the original execution plan?

I'm sorry to say it, but you probably need to gather more data. Can you get Perfmon & Profiler in place to see what is occurring when you run these...

Have you looked at an execution plan for the query? Maybe it's already using the index correctly? I wouldn't trust the results from the wizard. I've generally found them to...

Before you go throough the reinstall, be sure that you can connect to it using SQL Server Management Studio. You want to know it's up and running before you start...