The question title says OPENQUERY, so I didn't even see the typo lol.

-- webrunner

Thanks for the question, Steve!

Is the correct answer due to the fact that the restore is attempted while in the DNRTest database itself?

Thanks,

webrunner

LOL I was happy to get the right answers, and then I read that they are all right.

-- webrunner

Hi, have you tried this page?

http://whoisactive.com/docs/09_deciding/

HTH

-- webrunner

Thanks for the question, Steve!

Btw is this option complete, or was the sentence cut off?

"This enables a separate Query Store on secondary replicas that is"

Bumping this topic. Thanks for any help.

Thanks, everyone. I'll review the info you provided. The vendor is using this query to determine unused table space:

SELECT TableName
,NumRows
,reservedpages * 8192 / 1024 AS TotalSpace
,pages *...

• This reply was modified 1 years, 3 months ago by webrunner.
• This reply was modified 1 years, 3 months ago by webrunner.

Thanks, Steve! Always appreciate your QOTD.

-- webrunner

Two answers are the same. I wanted to pick that you can't have ORDER BY in a subquery but that wasn't an option.

Hi Johan,

Sorry for my delayed reply. Thanks! I'll check it out.

-- webrunner

Hi Ant-Green,

Thanks so much for this info! I'll test it out.

Thanks again,

-- webrunner

Hello experts,

Following up on this post, I found something interesting.

In the environment mentioned above, one of the AGs hangs with the connection timeout error, but another one connects successfully.

Does anyone...

• This reply was modified 1 years, 7 months ago by webrunner.

Thanks, Brian.

I'll double-check the firewall (B) possibility. I also think it has to be that.

-- webrunner

I'm a little late to the party due to the repost. But I look forward to reading more on this topic. We had a really terrible EAV implementation, so I...

Hi, thanks for posting that link. As of today, however, it leads to a 404 page. Does anyone have an updated or similar solution link?

Thanks...