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

jeffkretz (12/2/2008)

---

Jeff Moden (12/2/2008)[hrI wouldn't and haven't done that... I'd just as soon have the 40 interviews. I've met a lot of people who absolutely choke on a test...

Sergiy (11/28/2008)

---

Look at you WHERE clause:

WHERE l.List_ID = @list_id

AND CONVERT(int,l.CORP) = c.corp

AND CONVERT(int,l.FRAN_TX_AR) = c.FTA

Here is the answer.

1st, you may safely change datatype...

This is a system I inherited and I'm...