and please please do not create those fields as TEXT - define them as varchar if they are character based - and if the data is numeric or date and...

That link contains enough information to guide you on which one to chose - other than that it is TEST TEST TEST and pick the one that performs better for...

the tables you have contain a query hash - with that you can get to the other DMV's that may or not contain a session ID - there may not...

Thank you for your feedback, appreciate your valuable time, skills and know ledges. Do you agree if we have more than 5 millions rows in source table, we should...

for example when you have varchar max columns that compress very well (like email body (without attachments) and those columns will never be subject to a search.

in one of my...

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