Phil - it was combination of 3 db's for a migration project (insurance company).

• transientdb - source data
• persistentdb - etl db - had synonyms to both transient and product...

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

is it just me or does the OP here just think that we "should" answer all his/her questions without he/she showing that he made an effort of googling for whats...

you can try the following.

create a folder where you put the create scripts for those tables

on the projects where you need those tables ensure you have the folders...

you can try the following.

create a folder where you put the create scripts for those tables

on the projects where you need those tables ensure you have the folders setup correctly...

new queries only - so if you are seeing high cpu you will need to use a few dmv's to figure out which queries are taking that cpu

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