Table Size: 2 GB

Index: cluster index on identity column, three non cluster index

index size: 3 GB

cluster index insert

row count:38968909

Soooo, you have just 2GB of data yet 3 NC indexes...

mohan.mariyappa (8/31/2008)

---

I have below table with 10594358 records. When I tried to execute below update statment, it is executing for 9 mins and I stoped it. I have index on...

Hey, if you think you can guarantee that only one row will ever be inserted/updated at a time then your trigger will be OK. The problem is that you...

nithin.gujjar (8/28/2008)

---

USE [Religare1]

GO

/****** Object: Trigger [dbo].[NEWACTIVEID] Script Date: 08/28/2008 13:52:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[NEWACTIVEID] ON [dbo].[Client]

FOR INSERT

AS

BEGIN

Declare @clientid int,

@id int,

@pw char(2),

@activeid char(9),

@luhn...

YOU may think so, but the regulars here won't. 🙂

GilaMonster (8/26/2008)

---

Be careful with DTA. It has a habit of over-recommending things. Take its recomendations with a large pinch of salt and test carefully before putting the indexes it suggests...

Task manager: Processes tab: View menu: Select Columns

1) >> We are using AWE: we have locked the working set to 11.5 GB (we should probably increase that).

NO you shouldn't, not if you are already...

I would look for queries with very high IO as well, and check the plans for spools. Also UDF usage can lead to wicked bad looping queries. Likewise...

cool_itprofessional (8/24/2008)

---

i am having a server with 6GB RAM, Xeon Processor, windows server 2003 x64, sql server 2005 x64. we are using this server to handle datastorage of a hospital...

AFAIK the answer to both is no. But I am not declaring this to be the definitive answer.

I do think that the Dev edition of sql server is pretty...

1) You have not been upfront with us. Your original post did not have nearly the stuff in it this query does:

insert into #download

...

1) is there an implicit conversion happening in the year month value?

2) Can you print out the dynamic sql you are executing and provide it to us? Also, take...

Just a quick comment on the original post: ApexSQL is developing a debugger for 2005/2008 that blows away the one MS provides with 2008. One of it's better...

1) Use dynamic sql to execute the EXACT string that you would type into QA with NO variables. This will ensure proper query plan and partition elimination.

set quoted_identifier off

declare...