Ray K (1/12/2010)

---

This is more curiosity than anything else . . .

In perusing these forums, I'm noticing a great deal of geographic diversity (which I think is a great thing)!...

Steve Jones - Editor (8/11/2010)

---

Pages and pages of word pronunciations. I can't say I'd have ever thought that would be in here.

One a side note, I thought this was interesting:...

I'll have to pass on really answering the details of your question. 🙂

My personal experience has been that there is so much to learn from the DB admin and performance...

Glad you could get them and...

Unfortunately no. Sorry.

Not sure about the Performance Tuning book. I'm sure it is good though. The e-book that I was referring to can be found HERE on Simple Talk[/url].

It really provides...

Well, glad that worked - somewhat. Now for my disclaimer - when having to use join hints, index hints, etc it tells me that the optimizer is not able to...

Kit G (8/11/2010)

---

Ray K (8/11/2010)

---

Ah -- if I remember my Rochester geography correctly, you were in Chili or Henrietta (or somewhere thereabouts), is that right? I can describe my...

princa (8/11/2010)

---

The question is:

If I change where condition, say table1.age = 10, which will return 1000 rows, which uses hash merge join and returns in a second.

If I change where...

Glad it is working for you now. Definitely the metadata can cause problems and I have had success in cleaning that out manually in the past without removing replication completely....

The numbers returned by that query are very suspect. Try running select * from MSdistribution_agents on the distributor. I'm curious but are you using shared distribution agents? The issue you...

There is another version from Kendal Van Dyke that allows for the use of TOP N and thereby limits how nasty the query actually is. You can review this one...

Please read the following and post back with detailed questions;

Server memory options - http://msdn.microsoft.com/en-us/library/ms178067.aspx

Monitoring memory usage - http://msdn.microsoft.com/en-us/library/ms176018.aspx

It's odd that the replication type is showing snapshot. I would certainly call that suspect unfortunately. 🙁

You can drop that publication and create a new transactional publication and when...

While I agree with Roy that stopping the log reader agents is the nice way to do things, it is not necessary. I would be curious as to what error...