few comments on this

1. do not use nvarchar unless you have double byte data - use varchar instead
2. do not use names that require use of [] around them -...

thanks Jeff.

so a bit slower on my pc - I7 4 core , 16GB ram, SSD drive - 29 seconds for same criteria.

on this type of multiple files output, and...

your best option is to setup a GMSA/MSA and use that instead of a standard AD user - once you change them you won't ever have to worry about its...

I ran a test against your JBMTest table - here is the code that was executed and the Get-Date output.

All 53 files were created in about 15 seconds with...

was about to post the test code - Jeffrey second option has a typo which he corrected on the post above ( = $($_)" - was $($week)") so it would...

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

git command line would be the way to go - I have limited experience so can't really give you good details but have a look at https://docs.gitlab.com/ee/gitlab-basics/start-using-git.html

from a brief reading...

lots of ways to skin a cat 🙂

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...

And on a different note - there is no need for that extra unique index - if the hash is done correctly and it is based on those columns then...

Then go back...

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

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, 6 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, 6 months ago by frederico_fonseca.
• This reply was modified 5 years, 6 months ago by frederico_fonseca.