Sfrgttk

Is there any way to damage Intellect Devourer(s) when already within a creature's skull?

Single word request: Harming the benefactor

In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?

Does "variables should live in the smallest scope as possible" include the case "variables should not exist if possible"?

Is it true that real estate prices mainly go up?

Why is Beresheet doing a only a one-way trip?

How could our ancestors have domesticated a solitary predator?

Replacing Windows 7 security updates with anti-virus?

Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?

Should I tell my boss the work he did was worthless

Reverse string, can I make it faster?

Solving "Resistance between two nodes on a grid" problem in Mathematica

infinitive telling the purpose

Is there a window switcher for GNOME that shows the actual window?

Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?

Are the terms "stab" and "staccato" synonyms?

Is Gradient Descent central to every optimizer?

What to do when during a meeting client people start to fight (even physically) with each others?

Is there an elementary proof that there are infinitely many primes that are *not* completely split in an abelian extension?

Why don't MCU characters ever seem to have language issues?

Good allowance savings plan?

Make a transparent 448*448 image

Why the color red for the Republican Party

Should QA ask requirements to developers?

How to get the SQL Server object name from Query Store?

0

In Query Store how can we get the name of the SQL Server object, such as the Stored Procedure name, that created the query plan?

We could use a query like below, substituting in the query_id that we copy from the Query Store reports, but that's one-at-a-time and awkward. Isn't there an easier way?

SELECT o.name

   , o.object_id

   , o.type_desc

   , qs.*

FROM sys.query_store_query qs

JOIN sys.objects o

ON qs.object_id = o.object_id

WHERE qs.query_id = 555523

sql-server query-store

share

asked 2 mins ago

Conrad S.Conrad S.

484

add a comment | 

0

In Query Store how can we get the name of the SQL Server object, such as the Stored Procedure name, that created the query plan?

We could use a query like below, substituting in the query_id that we copy from the Query Store reports, but that's one-at-a-time and awkward. Isn't there an easier way?

SELECT o.name

   , o.object_id

   , o.type_desc

   , qs.*

FROM sys.query_store_query qs

JOIN sys.objects o

ON qs.object_id = o.object_id

WHERE qs.query_id = 555523

sql-server query-store

share

asked 2 mins ago

Conrad S.Conrad S.

484

add a comment | 

In Query Store how can we get the name of the SQL Server object, such as the Stored Procedure name, that created the query plan?

We could use a query like below, substituting in the query_id that we copy from the Query Store reports, but that's one-at-a-time and awkward. Isn't there an easier way?

SELECT o.name

   , o.object_id

   , o.type_desc

   , qs.*

FROM sys.query_store_query qs

JOIN sys.objects o

ON qs.object_id = o.object_id

WHERE qs.query_id = 555523

sql-server query-store

share

asked 2 mins ago

Conrad S.Conrad S.

484

SELECT o.name

   , o.object_id

   , o.type_desc

   , qs.*

FROM sys.query_store_query qs

JOIN sys.objects o

ON qs.object_id = o.object_id

WHERE qs.query_id = 555523

share

asked 2 mins ago

Conrad S.Conrad S.

484

share

asked 2 mins ago

Conrad S.Conrad S.

484

asked 2 mins ago

Conrad S.Conrad S.

484

asked 2 mins ago

Conrad S.Conrad S.

484