and what are advantages of using trace flags for saving deadlock data to transaction log compared to seeing them in the default XE sessions?

Thank you, Jeff,  for your

very valuable comment. And I am doing that , too (top 10 worst , etc.).

but aside along from that, there is a specific question asked me...

Thank you.

Is there anything in SQL Server that is analogous to Autonomous DB in Oracle?

and please do enjoy the attached booklet on Autonomous DB, my favorite book series.

Mine ran 45 minutes.... THANK YOU, GRANT, for your response this morning. Saved me a day of on submitting prod request/waiting for result.   This is more worrisome though: <<Now, in...

yes, I understand, thank you. But what do you test when you have

4000 transactions going all day and may be a 100 SPs that hit the table that got compressed...

Regardig columnstore index: When I replace the Clustered index with Columnstore Clustered index (CCSI),

There are 20 other Non-clustered regular rowstore indexes on same table. They are still there. Should I...

Well. I found query hash only in 2 DMVs:

* dm_exec_query_stats

* dm_exec_requests.

From the below definition, I am concluding that a query (every query trackable by Query Store) may or may not...

If you could give me a further hint, I would appreciate.

I thought that when I do the entire table compression with  REBUILD ALL all (non clustered) indexes on the table get rebuilt. Or do I need to issue a separate...

Tried... cannot do it.

Can't find what to link query hash to,

oh well.

Should I not even bother compressing non-clustered indexes?

what if my table does not have clustered indexes? it only has a composite primary key, non-clustered. And a dozen of nonclustered...

I simply did it in one of these two ways:  (isn't it the same as compression Clustered and non-clustered indexes separately? I thought the below statements do that)

create table tab74...

How else can I compress DATA?  You mean COMPRESS function?

or What do you mean by this:

<<Compess both DATA and Indexes - the command you gave only compresses the table (and...

-- NOTE: (Voldemar tested this out well, is very satisfied with this script, and even has it on daily baseline collector routine.  )

-------------------------------------------------------

-- The queries below need to be executed...