you don't use CDC instead of ETL - CDC IS a method that can be used as part of a ETL Process

I'm sure you can do a sample create table and insert statements of sample data to help us help you.

field names don't even need to mean anything so no excuse...

Alejandro, if you read the documentation you will see that the example given is indeed on the MS documentation as an option to start SQL Server on single mode and...

what are the reasons for not using backup/restore?

but the copy database option, using SMO, will copy all db objects - data will be the same with likely exception of timestamp/rowversion...

This will explain what it is.

I don't think full plan has columnstore segments data on it - but to confirm we would need the full explain plan file (to...

curious of what statistics io would say on both cases - specifically segments read / skipped which will be an output when table/index is a columnstore.

on this case I don't...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

Stanley bot - 1 spam post every 5 min. ARGHH!!

great explanation

should this be created as an article instead?

Lordy... there's a "bot" running with the handle of "Stanley" and it's posting spam every 5 minutes.  Between that and another bot that was active only for a while,...

if your source is a file then just split it on the file definition by setting up the file with comma delimited as column separator, quoted

and... if using compression space used will vary a lot depending on the compression type and on the data.

used to be 3 per post - and when it happened all posts for that user would be gone (not sure what happened to the user on the background)

on old...

with wordpress forums I think you need to have one of the addins to manage users - may not be able to delete it, but you can block it (with...

Alias requires you to change EVERY single client - its clumsy and not desirable if it can be avoidable

If the old server is not going to be used then a...

have a look at some options here https://alternativeto.net/software/remote-desktop-connection-manager/