Viewing 15 posts - 526 through 540 (of 1,790 total)
Ray K (1/12/2010)
In perusing these forums, I'm noticing a great deal of geographic diversity (which I think is a great thing)!...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 7:50 am
Steve Jones - Editor (8/11/2010)
One a side note, I thought this was interesting:...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 2:57 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 2:48 pm
princa (8/11/2010)
Thanks a lot David. I am able to download them and will spend sometime to read and may have questions just hit you. 😛
Glad you could get them and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 12:14 pm
Unfortunately no. Sorry.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 12:12 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 11:55 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 11:32 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 11:15 am
princa (8/11/2010)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 11:08 am
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 10:56 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 10, 2010 at 2:55 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 10, 2010 at 8:27 am
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 10, 2010 at 7:43 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 9, 2010 at 3:30 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 9, 2010 at 3:13 pm
Viewing 15 posts - 526 through 540 (of 1,790 total)