Ninja's_RGR'us (9/8/2011)

---

SwayneBell (9/8/2011)

---

Grant Fritchey (9/7/2011)

---

You all know Gail is on right now? She's doing great:

https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

I'm going on at 2300GMT or 7:00PM EDT

https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

You'll get close to 2 out of 7 hours...

First, go to the Microsoft and get the 2008 Upgrade Advisor. Run it against your 2005 database. If there are any major issues, it will identify them. Otherwise, it's an...

Roy Ernest (9/7/2011)

---

Grant Fritchey (9/7/2011)

---

You all know Gail is on right now? She's doing great:

https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

I'm going on at 2300GMT or 7:00PM EDT

https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

You'll get close to 2 out of 7 hours...

You all know Gail is on right now? She's doing great:

https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

I'm going on at 2300GMT or 7:00PM EDT

https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

You'll get close to 2 out of 7 hours of our precon this...

When you create a foreign key, it's a constraint, not an index. If you want an index on a foreign key, that must be created separately.

You can look at the...

Schadenfreude-Mei (9/7/2011)

---

SwayneBell (9/7/2011)

---

I was disappointed too Grant, what with my...

Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.

Sounds like something going wrong on the Windows Server. Have you checked there for errors?

ravindranath.s (9/7/2011)

---

Actually my sql statment like this

SELECT DISTINCT UPP.ProductID,dbo.fnGetProductTestStatus(UPP.ProductID,@UserID) AS EndDate ,

FROM #UserProductProgression UPP

when i say like...

Also, you're saying "similar" data sets, not identical data sets. Similar can be pretty radically different depending on the data distribution.

Also, no mention of any measure for contention. Are you...

Well done Gail. The place just wouldn't be the same without you.

106919046 (9/7/2011)

---

Hey, I totally agree with Ian Scarlett.

If your files change alot. I recommend you use incremental backup instead of deferential backup.

Recheck your backup task, see if it did...

If the vendor won't support the upgrade, don't do it. Even if you only hit very minor issues, they can disavow all support and you're on your own. If you...

Then you shouldn't be surprised if it slows things down. Make sure you're running these processes at the slowest part of the day because they will affect each other. If...

ananda.murugesan (9/5/2011)

---

Thanks for reply...

I understand for IO never become 0.0.

Could you tell me, what is actual value output for most IO query and what is generally perfered value of IO...