Viewing 15 posts - 316 through 330 (of 1,790 total)
Nope, transactional replication can definitely handle it. If you start running into latency give a post back and we can work through that.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 1:25 pm
Krasavita (2/23/2011)
Microsoft SQL Server Management Studio9.00.4035.00
Microsoft Analysis Services Client Tools2005.090.4035.00
Microsoft Data Access Components...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 12:44 pm
Definitely agree, PSS is the way to go here. Please post back with what you find.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 8:37 am
Great. I was beginning to wonder if that was the issue which is why I posted that last query. Glad you got it working and thank you for updating.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 6:57 am
I'll have to write my perceptions on remote working but will say that I have been working remotely either part or full time for the last 5 years with the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 6:55 am
Is it occurring consistently or sporadically? If consistently then there is probably something seriously wrong with the SAN, either in the communication layer or the controller and possibly at the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 8:26 pm
If you are going to continue to restore the log backups then you are going to have to leave it in recovery making it unusable as well.
Have you read...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 2:50 pm
Yes, that is a log shipping scenario. Is there a reason you wouldn't just use Log Shipping rather than building this up yourself?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 2:32 pm
GilaMonster (2/22/2011)
If your code is that valuable, the only option that will protect you is to host the SQL server yourself and never give the clients the databases. Anything else...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 1:22 pm
something like this should work;
select object_name(id) from syscolumns where name = 'col1'
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 12:36 pm
sdffdfad faadffad (2/22/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 22, 2011 at 10:49 am
yuanyelss (2/18/2011)
The issue scales with volume anyway and the particular query is largely irrelevant. A query that runs <1 sec on the test box takes 23 seconds on Prod...
What are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 10:07 pm
Sean Lange (2/18/2011)
David - yours is about half as much typing as mine but has a lot more +1 -1 than mine. They both certainly work equally well. :hehe:
Yeah -...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 3:27 pm
Sean - you beat me and I think yours looks cleaner but I'm posting anyway. 🙂
DECLARE @string VARCHAR(50)
SET @string = 'IA_JOOWEN_1-F3D9NN'
SELECT SUBSTRING(@string, CHARINDEX('_', @string, 1) + 1, ( LEN(@string) -...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 3:21 pm
Can you verify that this query returns 0 rows when run in your publication database;
SELECTsp.name AS publication_name,
ss.srvname AS subscriber_name,
sa.name AS table_name
FROMsyssubscriptions ssJOIN sysarticles sa
ON ss.artid = sa.artid
JOIN syspublications...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 2:05 pm
Viewing 15 posts - 316 through 330 (of 1,790 total)