Tara (7/17/2009)

---

as i said most of the time we only do SELECTS on the databases...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Tara (7/17/2009)

---

Here is one of the sample queries

drop table #emp

select distinct EMPID

into #emp

from vwEmp_act

where (place IN ('21','25','51') or (empcd = '1' and jobcode = 'Y'))

AND empflag = 'F'...

Tara (7/17/2009)

---

There are no PK;s since begining but they do have clustered index I dont think if that serves as PK , Actualy we do not have a unique key...

Maybe give Microsoft's customer support a shout. I've heard of a case where the rebuild says it succeeded but didn't, not sure why that could happen. Calling CSS will be...

You need to find the actual error. There's nothing much of use there. Go to the job step, go to the advanced tab, there's an option there to output the...

Why no primary keys?

With performance problems, the first place to look is the queries and indexes, not the hardware. These two articles may help you get started.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Google for 'index rebuild site:sqlfool.com'

When the results page comes up, click on the 'cached' link. Voila.

Ok, you didn't say so before.

Something I used to use to get past the bank's security (which may or may not...

Because they rebuild all indexes every time they're run regardless of whether or not the index needs rebuilding. It's a waste of time and resources to rebuild an index that's...

A great deal of patience and gritted teeth. I should have gone into more detail on my...

Personally I wouldn't use the maint plan rebuild unless it's a small database. Get one of the index rebuild scripts that only rebuilds if the fragmentation's excessive. There's one on...

Grant Fritchey (7/16/2009)

---

GilaMonster (7/16/2009)

---

Agreed, though I have seen a case where someone got an error when trying to create an index because that limit had been hit. Table was a...

Maybe....

Now I've got that out of the way, some details. Auto-update ensures that the stats will get updated once more than 20% of the table has changed. That's a large...

Please post index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/