Viewing 15 posts - 2,281 through 2,295 (of 5,393 total)
Decrypt from what encription?
-- Gianluca Sartori
December 1, 2011 at 4:38 am
Suresh B. (12/1/2011)
COPY_ONLY does not break the log chain.So if you have log shipping configured, you can use COPY_ONLY option to take a full database backup of testing, etc.
COPY_ONLY...
-- Gianluca Sartori
December 1, 2011 at 4:34 am
ps. (12/1/2011)
keep ur db in bulk logged recovery and then use bcp. this will be faster.
While exporting? Are you sure?
-- Gianluca Sartori
December 1, 2011 at 4:13 am
It's not a lot of data IMHO (I could be wrong, I guess lakths means 100.000).
SSIS would be the faster, BCP would work just as well.
-- Gianluca Sartori
December 1, 2011 at 3:47 am
DTS is old and deprecated. Use SSIS instead.
If this is a "one shot" operation, you can use the Import/export wizard or BCP.
Hope this helps
Gianluca
-- Gianluca Sartori
December 1, 2011 at 3:11 am
select *
from sys.dm_os_performance_counters
where counter_name = 'Total Server Memory (KB)'
Run this on all the instances and you'll get the whole picture.
-- Gianluca Sartori
December 1, 2011 at 3:10 am
SELECT *
FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM PMSPYP00') AS RemoteTable
INNER JOIN MyTable AS LocalTable
ON RemoteTable.SomeKeyColumn = LocalTable.SomeKeyColumn
-- Gianluca Sartori
December 1, 2011 at 2:30 am
Are you using a linked server? Which OLEDB provider are you using?
Some things to check:
1) Isolation level
2) Two phase commit
3) Table journaling
What error are you getting?
Looks like you're...
-- Gianluca Sartori
December 1, 2011 at 2:10 am
alaguganesha1983 (11/29/2011)
Try replication between the two server.
Seems to me a bit of overkill for just a couple of tables...
-- Gianluca Sartori
November 29, 2011 at 2:13 am
Sorry it took me 6 months... :blush:
I posted a corrected version of this code on my blog:
http://spaghettidba.com/2011/11/28/email-alert-dbcc-checkdb/
I hope you will find it useful.
-- Gianluca Sartori
November 28, 2011 at 4:02 pm
No sysadmin privileges? No way to enable CLR AFAIK, sorry.
Talk to your provider, they may consent to enable CLR if you support your request with good points.
-- Gianluca Sartori
November 28, 2011 at 3:05 pm
Linked servers are good for small batches that involve little or no data movement.
SSIS is much more efficient when moving huge amounts of data.
-- Gianluca Sartori
November 28, 2011 at 3:02 pm
MysteryJimbo (11/28/2011)
This has an impact on replication as well.
Correct, but I don't see replication mentioned anywhere on this thread.
-- Gianluca Sartori
November 28, 2011 at 10:06 am
sqlfriends (11/28/2011)
What is the best way of doing this without using much space, I don't need the transaction log for this process.
There's no way to ignore or discard the transaction...
-- Gianluca Sartori
November 28, 2011 at 9:53 am
Sean Lange (11/28/2011)
-- Gianluca Sartori
November 28, 2011 at 9:18 am
Viewing 15 posts - 2,281 through 2,295 (of 5,393 total)