if you are following Data Vault design then you have too many columns on that hub. most of the columns there look like attributes of your business key and are...

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

thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has already set that...

Can you please state what is the size of the log file - I did ask for it to be supplied separately - if your datafiles are 300GB and your...

I think this may depend on the company and even on the country.

I've been contracting for over 30 years - first 10 in Portugal - not quite that good (bad...

you can install OpenXML SDK and use that to create Excel Files without the need for Office to be installed.

But yes it does require coding in C# to do...

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

try this from Brad Shulz http://bradsruminations.blogspot.com/2011/01/so-you-want-to-read-csv-files-huh.html

it may do what you need

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

you can use the one you desire.

and you need to change "-t7z" to be...

this is what I do in some (old) packages

note that the "add to zip " does not delete the files - on newer versions you would need to add "-sdel"...

you automate it in a similar way to winzip (assuming you were using the command line interface and not the c# dll)

I'll dig some of my examples and post here

Thanks Frederico. So you agree that CDC is similar to SQL Server transactional replication? Since setting up SQL Server replication also requires all tables to have primary key. You...

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

Thanks! Has anyone has any thoughts on Change Data Capture.  The CDC function is, probably similar to the transactional replication.  It is not the same, but it has this...

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

few questions.

• what is the size of db - logs and data sizes separate
• is IFI enabled on the server
• was compression enabled on the backup (it should have)
• how...

and I've just noticed - the view code above does not correspond to the one that the explain plan is referring to.

JD.vw_Orders is the view used on the explain plan...

according to the plan it was called with

Parameter Compiled Value Runtime Value

[@ONum] '31856258' '31856258'

downloading the plan from the link does have all the info as far as I can see, including predicates.

and from what I can see it is only the view that...