Viewing 15 posts - 31 through 45 (of 98 total)
https://www.sqlservercentral.com/blogs/vinaythakur/archive/2009/10/23/tricks-and-issues-part-1.aspx
HTH
Vinay
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!591.entry
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
November 18, 2009 at 2:31 pm
http://msdn.microsoft.com/en-us/library/ms143241.aspx
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
October 27, 2009 at 2:48 pm
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!591.entry
and if we want to export into xls we can use the below query but we have to give heading Name onexcelTargetfile.xls file before running this query:
INSERT INTO
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
October 26, 2009 at 1:49 pm
it will clean up every after "Distribution clean up: distribution” job runs.
http://www.replicationanswers.com/TransactionalOptimisation.asp
HTH
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
October 22, 2009 at 10:32 am
Right...
I would backup and restore on subsriber and set up the replication with nosync( subsriber is already having data)...
my one cent.
Thanx.
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 2:47 pm
I would say it could be something (might be Network) causing this issue.
Before commenting on anything we have to investigate the system completely like
1. what DTS is doing?
2. at that...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 2:43 pm
my suggessions would be:
1.you can use replication (snapshot/transactional)?
2. use bcp that will be fast for small tables if your transfer is not very frequent(once a day) and less records?
but replication...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 2:38 pm
If you have more then 255 columns if possible go for log shipping or other technique.
For replication: normalize the tables(as you stated) and replicate both tables.
HTH
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 2:29 pm
Here is BOL:
"Subscriptions expire and are dropped if not synchronized in the following number of hours/days
Set the number of hours for snapshot and transactional publication, or the number of days...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 2:02 pm
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!218.entry
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 9, 2009 at 6:53 pm
Thank you all for all your comments....
This is my first post QOD to Sql server central...We have some sql server 2000 setup which we migrated from older version (I know...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 7, 2009 at 8:21 am
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!208.entry
my once cent...
HTH.
Vinay.
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
July 22, 2009 at 10:29 am
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!208.entry
HTH.
Vinay
*Nothing is easy...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
July 22, 2009 at 10:27 am
That is ok.... what is your issue, dont recompile or free cache. its not always good specially on sql server 2000 its batch recompile where as on sql server 2005...
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
June 15, 2009 at 2:48 pm
http://www.sqlservercentral.com/Forums/Topic375915-146-1.aspx
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
June 8, 2009 at 10:02 am
Viewing 15 posts - 31 through 45 (of 98 total)