Scott - Thanks for the reply. So when you stop the Agent, what happens to the jobs that were supposed to run during the stoppage? That's mainly...

Does your  initial query return values?  If not, the variables will not contain values.

Does it get inside the IF statement?  If not, then the initial query is not producing a...

Hi ...I am a newbie to SQL.......Help me with the below req for the table below

drop table sample_data go create table sample_data ( rn int , dur float )...

They never really provided an example.

If this is an availability group, why do you need shared storage?

We configured it separately on each server.

Use the MAX function on the date, and group by the columns that uniquely identify the city.

Put that in a subquery, and join the table to the subquery on all...

Thanks Michael,

Just...

What problem are...

Make the service account a sysadmin, and see what happens.

This article describes what permissions are required.

https://docs.microsoft.com/en-us/sql/relational-databases/replication/security/replication-agent-security-model?redirectedfrom=MSDN&view=sql-server-ver15

They code base is identical.  The only differences are the licensing.

Curious, why would you think that there may be a performance difference?

VS 2017:  I do not have the Business Intelligence option for Integration Services.  What needs to be installed for VS 2017 to allow me to create SSIS packages that...

Can you attach the execution plan?

Good article.  One critique.  You use of abbreviations in the object names made this difficult to follow.  dname?

If there is a specific set of requirements, such as auditing or compliance, where you need to isolate these environments, there should be no need to keep things the way...

SSAS changes are not captured in the default trace.

You can set up a separate trace for SSAS.

This explains it.  https://sqladm.blogspot.com/2014/01/audit-log-for-analysis-services.html