Jeff Moden (2/1/2009)

---

Marios Philippopoulos (2/1/2009)

---

RBarryYoung (1/31/2009)

---

Marios Philippopoulos (1/31/2009)

---

I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical...

RBarryYoung (2/1/2009)

---

Marios, I think that what you gav eus before was the estimated execution plan. Can you get us the actual execution plan? IT should also be avaialable...

Sure, here it is. I had posted this code in a previous posting (http://www.sqlservercentral.com/Forums/Topic630749-360-4.aspx), and you had correctly pointed out that some of...

Thanks guys for your responses.

I should clarify that this is not a one-off event.

Whenever the trigger is executed, the number of reads is always in the millions, while the...

RBarryYoung (1/31/2009)

---

Is this for one...

Here is the correct exec plan (attached)

matt stockham (1/30/2009)

---

You may be fine, but it depends on the workload.

Because SQL is reading an extent at a time from disk, you wouldn't want the average fragment...

DavidB (1/30/2009)

---

If I was migrating to SQL Server 2008 I would try to start out as high as I could so that I didn't have to do it after the...

Thank you!

Which version would you guys recommend?

Thank you! 🙂

David Kranes (1/29/2009)

---

Hello, I am upgrading an application from SQL Server 2000 to SQL Server 2008 and I need a good resource that will outline all the known issues in...

huscyp (1/29/2009)

---

thanks.It was clear.

SO lets take an example , where our database will be 2TB very soon and there are some tables which will be very big.how we should divide...

Harold Buckner (1/28/2009)

---

How hard of a change would it be to add the blocking User info.

For example we have the blocking spid and the blocked spid and we have...

Nilesh Patel (1/28/2009)

---

I was able to find answer on how to set alert for specific monitor. It needs to be done using script as mentioned in

http://blogs.msdn.com/jakuboleksy/archive/2007/01/18/notification-subscriptions.aspx

We did not feel...

matt stockham (1/28/2009)

---

I added the -h parameter to sqlcmd to drop headers. You also need to set nocount or parse out the returned values to only return valid instances....