Sure, sure, sorry. the script attached.

beautiful thing.

Criteria for Columnstore candidate table selection is listed in the comment.

THANKS!

Question: can there be any reason that an error will be thrown while attempting to compress the table? Like what should be 'wrong' with table to cause the compression to...

The saved results look like in the attached screenshot.

My other doubt is whether it is worth at all to save/persist this info for baselining or other purposes.

Should the results of...

Thank you!

dm_db_index_usage_stats  helps.

I did this

but test result from resting the entire SP  (before and after)  that this statement is a part of was different, that's why I doubted.

AND (@i_PARAM1_field = @i_PARAM3_field OR...

Ok. Thanks.

I got it this way:

SELECT

job.job_id,

notify_level_email,

name,

enabled,

description,

step_name,

command,

server,

database_name

FROM

msdb.dbo.sysjobs job

INNER JOIN

msdb.dbo.sysjobsteps steps

ON

job.job_id = steps.job_id

WHERE

sysjobsteps.Command like '%table1%'

OR

sysjobsteps.Command like '%table2%'

ok. now i fully see how it is working. But since we are going to run this job on Sundays only, so we are fine with the code then. I...

but then why to juggle it ti like that

This whole thing returns date of midnight following the today's date.

Like what are we saying? Delete all records that are dated earlier...

Thank you! I cannot believe I either forgot or did not know about default value for 'zer0' or for  ' ' for datetime datatype...

I ran this to confirm.

create table wdi(datum...

it appears that select DATEDIFF(wk,0,GETDATE())

returns 6271 , which . divided by 52 - 120 years.

so it is weeks since the year 1900.

yes, you right. I just assumed that. it is not what it means. What does parameter value = 0 mean in Datediff function in such case?

this part confuses me:

DATEDIFF(wk,0,GETDATE()),

and this was a one time run query in prod, not scheduled. Deleting old rows... i actually need to make an SP out of it with params...

1. I believe it was 64 bit  Should it be 32?...
2. TNSNames file has an entry for server named ORCL, I did not manually set up anything additional . Should...

THIS works:

WHERE ((T.record_Key_4 = '1' OR T.Record_Key_5 NOT IN('I', 'X')) AND PS.popup_gid = 2)

OR ((T.record_Key_4 <> '1' AND T.Record_Key_5 IN('I', 'X')) AND PS.popup_gid = 5)

thanks for your help !!!

here is Create Table DDL.