what columns does the table have?

which column(s) were you thinking of creating the index on?

are you running server side trace or through profiler?

what events are you capturing?

try this link

http://sqlug.be/blogs/wesleyb/archive/2007/07/25/memtoleave-issue-in-sql-server-2000-x86.aspx

sounds like a job for SSIS!

replication doesnt replicate all objects, for instance if one of your tables has no PK it will not replicate. Then you have all the stored...

how much cash do you have basically, clustering will cost more to implement and administer

i have found detach, copy and re attach generally quicker

if you're uncomfortable with T-SQL you can via management studio drill down through tables to the index level and right click then select rebuild all

splitting tables uses partitioning.

Fill factors are used for index build operations and determine the fill level of the leaf pages.

do you mean partitioning tables?

rbarryyoung (11/17/2008)

---

Well, let's see:

Usually on my cell phone as...

that's not how it works, a virtual CPU has no knowledge of cpu cores. The physical host is licenced per physical socket. You need to weigh up your licensing requirements....

that's not what he requires

your welcome

Ted Stryker (11/19/2008)

---

I was afraid you were going to say that 😀

There's nothing else running on the box, max server memory is set to leave 6gb for the OS and...

venki

you can of course also use the management studio if you prefer GUI interraction

RAID 1+0, this requires even more disks than RAID 5. It would...