Nicholas Cain (1/2/2009)

---

You've got a primary key, why not put a clustered index on it?

Anyhow, try removing the WITH FAST option and see if you get different results. Per BOL...

Many of us prefer to backup to local disk, then copy the flat file to tape later. Faster & more reliable

For some reason the application that we bought does not use clustered indexes. Most of the non-clustered have been moved to the other file group on G.

Some unique primary key...

Does that still apply if the indexes are on another drive ? I'm thinking...

I'm running 2000 SP4

Maybe you some processes that are blocking other processes ?? Hardware won't fix that. Do you see any blocking during slowness ?

This leads into the Fill Factor option. I think the default is 0 (effectively 100 %). In an application with lots of I/O, would 80% be better ?

Matt Miller (12/30/2008)

---

I consider clustered indexes essential on damn near every table. About the only time a heap is better is when the data in the table is "write once,...

So, thanks to you guys my brain is finally starting to catch on !

I could force the query to use the index, but then I run a future risk of...

Is there a downside to...

GilaMonster (12/30/2008)

---

Take a mid-sized computer book with a comprehensive...

"isn't SQL doing 55 million seeks"

I meant to say: Isn't SQL reading 55 million rows instead of reading 422,000 rows ?

"Is that all the columns in the table?"

No, I just...

GilaMonster (12/30/2008)

---

Yes. Because you're doing a select * , the index...

Nevermind .... I asked the Network assistant and he set me up in 1 minute.

eseosaoregie (12/3/2008)

---

I need to restore 2 tables from for a database for me to able to run some necessary queries for work. The IT engineers have said they can restore...