Can you post the proc, the table and the index defs? Are there certain columns that will be more frequently searched than others?

What do you mean by 'clustered drive'?

Did you select the client tools during the install?

Note if you have developer on CD, that there are 2 CDs, one with the server components and one with the client...

Ah. Makes sense.

Biggest things to keep in mind is to not reference any DB other than master within the trigger, make sure that there are no permissions issues (I recommend...

matt stockham (9/23/2008)

---

Nice article. I have a few questions:

1) why do inserts scale so much better than updates and deletes on a workstation? A page is a page,...

Jeff Moden (9/23/2008)

---

GilaMonster (9/23/2008)

---

On a fairly active server I used to work with, on SQL 2000 we were writing a 200MB C2 file about every 15 min. After we upgraded...

Dunno about the OP, but I had a very similar piece of code in one...

Pretty much.

Ahmad Osama (9/23/2008)

---

GilaMonster (9/23/2008)

---

To recover in this scenario you need a full backup from before the table was dropped and an unbroken log backup chain from that full backup up...

Heaps don't suffer page...

The main problem I would see is the learning curve. MySQL can run on windows, but it will still require some time to get familiar with the admin requirements and...

fais (9/23/2008)

---

I see some columns in sys.dm_db_index_operational_stats like leaf_insert_count,leaf_delete_count,leaf_update_count......................... Have microsoft changed prior functionality into this............Please let us know if you know something (or) anyway to modify the script.............(or)...

Not using the native backup tools.

You can always bcp the table out, or make a copy of it in another DB with select .. into

Pleasure

Why not ask...