Viewing 15 posts - 481 through 495 (of 1,790 total)
agnnga (8/24/2010)
As mentionned in the subject, would you tell me what are the differencies (with details) between those technologies in term of performance, broadband and simplicity? Or it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 24, 2010 at 7:04 am
just name and half a dozen address fields
And you can't group by these to get a distinct set of organizations? You will still have to scrub the name but...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 24, 2010 at 6:45 am
Jeff Moden (8/23/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 23, 2010 at 9:59 pm
Jeff Moden (8/23/2010)
Well done Mr. White!
Completely agree. I started sharing that around work late last week. Nice stuff!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 23, 2010 at 9:46 pm
jf577 (8/23/2010)
Push replication: 10 of 11 tables, sps, udfs, etc on...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 23, 2010 at 2:38 pm
PaulB-TheOneAndOnly (8/23/2010)
To make a decision look at: Size, Criticality, Budget, In-house skillset and your Personal preference.
....and available talent in your area. Don't pick a platform only to find out that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 23, 2010 at 6:35 am
Sorry, haven't used Litespeed in quite some time and I don't remember any of the features / tweaks. :doze:
This is probably best asked on the Quest support forum. I'm sure...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 20, 2010 at 3:14 pm
Check out PerfMon and look at the counters for SQLServer:Databases Transactions/sec. That should allow you to collect the numbers you need.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 20, 2010 at 1:59 pm
I'm assuming that the agent that you are referring to is the snapshot agent and not the distribution agent.
Secondly you could get the data across outside of replication and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 1:21 pm
One note about memory configuration that is often missed as follows;
"Note that the max server memory option only limits the size of the SQL Server buffer pool. The max...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 7:56 am
Yes, that is correct. That is all that I know how to get from T-SQL aside from what you originally posted.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 7:37 am
YTZ (8/19/2010)
Is there any t-SQL script that can work from Query Analyzer?
This will get you the physical node name;
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
However, if you don't have access to Cluster Manager then...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 7:24 am
Cluster Manager will provide you with all that information.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 7:17 am
You will want to read up on conflict resolution. Check out THIS SITE.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2010 at 6:52 am
NJ-DBA (8/18/2010)
Thanks David- will give that a shot. Will cut it in half and see what that does to the TLog size.
Post back with how this goes and what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 18, 2010 at 6:26 pm
Viewing 15 posts - 481 through 495 (of 1,790 total)