Thanks very much.

I'll focus on networking issues.

Thanks very much!

That's exactly what I needed.

Just to update, that worked perfectly. And to reiterate, here's what I did:

1. Connect to the Mirror DB Server, open SSMS

2. Execute this script to find the file names:

USE...

Thank you very very very much for that article.

I'll be testing that on my dev server and if it goes we'll I'll run it on the real one tonight.

Unfortunately (from a debugging perspective anyway), the problem has now gone away, ever since I added the new index on the dbo.Profiles_PracticeAreas table.

Since this has actually improved performance in the...

Oops. Sorry I didn't get the full package together.

Incidentally, since the Profiles_PracticeAreas table was causing the table scan, I just now added a new index on the Primary Key...

The CROSS APPLY solution is pretty interesting, I haven't messed with that type of query before.

I did some timed tests using Jeff Modon's million row test table, which I modified...

I was surprised to find out about this, as I am already using 2008 R2.

I fiddled around with a number of queries and as near as I could tell, the...

Oksana March (12/2/2008)

---

My dear friend Jeff Kretz,

yes, learning is very important but if I was in your place and make so much money as you, I would not get critical...

Gaby Abed (12/2/2008)[hr

Agreed...I'm working on my MCTS for SQL 2005 but I plan to emphasize my experience first on the resumes and keep the certification at the end, probably as...

Steve Jones - Editor (12/1/2008)

---

The storage engine is interesting since you learn how things work inside the server. I'd also pick up Grant Fritchey's Execution Plan book from Red Gate...

GilaMonster (12/1/2008)

---

Agreed. Where in the world are...

Thanks for that, I've added 3 of the Inside SQL books to my Christmas wish list (what a Geek, right?).

I realized I also may have an irrational dislike for the...