If the query is really long and it's creating and loading huge temporary tables, it won't complete the transaction and clear the log of those temporary tables until the context...

The problem is, executing a dynamic query like that is creating a different execution context. As soon as that context clears, which happens when the execution finishes, the temporary table...

Also, for what its worth, you're doing unecessary work, selecting into the temporary table and then selecting from the temporary table. Instead, just use the select statement that would load...

Suspended means waiting. Something interrupted the process and it's in a wait state. I'm not that familiar with Access, but from what you're describing, Access is in some manner holding...

Either way you go, to ensure that you're getting the exact same result set you need to use ORDER BY to ensure that the 1000 rows you get is the...

Everything Gail said and look at your execution plan (I'm getting sick of typing that. Anyone have a macro?) to see which indexes have a positive affect and which have...

This looks like a fun one to pile on to

1) A bit field, all by its lonesome, can be a horrible choice for an index (although in rare circumstances as...

Some like this would work. Instead of just the SELECT statement, use that statement with an INSERT statement into the auditing table of choice.

DECLARE @SqlString NVARCHAR(MAX)

DECLARE @DbName NVARCHAR(MAX)

DECLARE MyDatabases CURSOR...

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...