Try

SELECT *

FROM sys.dm_exec_query_stats QA

CROSS APPLY sys.dm_exec_sql_text(QS.plan_handle) ST

See if that gives you what you need.

Have you looked at this?

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-current&preserve-view=true&tabs=sqlpool#copy-a-database

My company sent out a survey asking what folks wanted to do.

2% want to work five days a week in the office.

40% want flexibility to work some days in the...

As a fellow standard user, I feel your pain 🙂

We use logshipping for one server at our DR datacenter and replication from our production server to our reporting server....

1. An availability group with standard edition does not support read-only secondary.  You can however use a snapshot of the secondary for reporting.
2. Mirroring does not support a read-only secondary.

...

Why wouldn't this work?

SELECT [Invoice Number],  Status, MIN(TimeStamp) ChangeDate

FROM YourTable

GROUP BY [Invoice Number],  Status

ORDER BY MIN(TimeStamp), [Invoice Number],  Status,

What is your question?

First and foremost - I AM NOT A SYSTEMS ADMIN

I'm a DBA. My windows admin and I built a sql cluster to do availability groups. It was both of...

The smart ones will respond that they will have...

Maybe.  Maybe not.

Typically the generic rule is if users access the data, then it needs to be licensed.

But, do NOT rely on the advice in a forum for licensing questions. ...

If you are using the GUI, you need to run as admin.

Otherwise, script it out and it should work

This is a good place to start.

https://www.sqlservercentral.com/stairways/stairway-to-alwayson

Nope......

By the way, today is Steve Jones birthday!!

Happy Birthday!!!

Are you old enough to know better yet??

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the licencing...