Well using a NOLOCK might mean that the engine is not putting a SELECT lock on the table (which it releases as soon as it obtains it).

Other than...

Itzik Ben-Gan has a post somewhere about the pitfalls of WITH (NO LOCK) and the inconsistent data results it can cause. With SQL 2005+ I just depend of Read...

hydbadrose (10/21/2008)

---

I am not asking for the process. All I am asking is when you move the nonclustered indexes to other disk array do you need the schema change or...

By default only the first 256 characters are returned in Query Analyzer/ Management Studio. To do increase this, go to the 'Results to Text' tab under Tools > Options >...

GilaMonster (5/13/2008)

---

Checkpoints are internal operations. They won't show up in profiler

You can log the output of:

SELECT * from sys.dm_exec_requests where session_id < 50

Log it every few sec. You should see...

I assume that you mean that each are setup in a Dev db on the same server.

What's the row count difference between the two?

Have statistics been updated in each db...

They should show up when you run profiler against your db.

nKognito (5/13/2008)

---

Let me explain my problem:

I have a one table with huge data size (its about millions records and gigabytes in size) and without any foreign keys. My actions are...

Jamie,

So then fire up Profiler.

Get a Trace ready to go.

about 30 seconds before the query is supposed to run, start the trace.

Stop the trace as soon as the CPU goes...

How many disks are in your array?

I have a similar situation and routinely replicate hundreds of thousands - millions of rows in just a few seconds?

I guess that a better...

No.

I'm a member of Baarf. 😀

I would never do such a thing.

In my experience with OLTP SQL Servers restarting is a bad thing from a performance standpoint. You loose you're query plans.

Back in the SQL 2000 days if we rebooted...

Where is your distribution db located?

Is it on fast disks just like your transactional db that you are trying to replicate? If so, is it on the same set...

I'll just say that my experience was pretty positive.

It didn't eat up much CPU or I/O for us and virtually completely cleaned up our blocking issues.

I hoped that helped a...