first - CDC is available since 2008 at lest - Maybe you are talking about temporal tables?

For recording the changes you can implement a delete trigger - and for each...

that being a VM - if Vmware ensure that

• Ballooning is disabled
• Max memory is set correctly on SQL Server instance - and leaving at least 1GB for the operating...

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 5 years, 7 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, 7 months ago by frederico_fonseca.