so you are telling us that you went through the documentation on over 160 dmv views and you didn't find any other view that has a query hash column?

even a...

as you were told on your other thread about this (and please do not create multiple threads) you do each individually - which by now you should already be aware...

DON'T do it is the correct answer. All columns should have the correct data type for their content and purpose.

Null is what you should be using - fact you don't...

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