I think this is what the OP desires

select ID
     , DocNumber
     , InternalNumber
     , DocumentDate
...

one option is do the deployment through t-sql

requires that bulk admin is granted to the devs (but not a big issue normally)

use SSISDB
declare @projectbinary as varbinary(max) =...

lots of info can be achieved as mentioned.

On my shop for some of the critical servers we don't even use sp_whoisactive but we use the DMV's to get similar information...

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 6 years, 2 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 6 years, 2 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 6 years, 2 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...