TechQA.

Question

JOIN on partition_id or hobt_id?

score 110 · Answer 1 · 2023-10-26T22:52:51.753000

0

Answer

110

Views

JOIN on partition_id or hobt_id?

110 views Asked by Michel de Ruiter At 26 October 2023 at 22:52

score 221 · Answer 2 · 2023-05-31T06:53:24.683000

Delete from SQL Server 2017 QueryStore dmv issue

221 views Asked by Geri Reshef At 31 May 2023 at 06:53

score 65 · Answer 3 · 2023-03-13T21:05:15.160000

VERY strange behavior of sys.dm_hadr_database_replica_cluster_states in a SQL Job

65 views Asked by Max Isaev At 13 March 2023 at 21:05

score 347 · Answer 4 · 2023-03-07T16:17:29.853000

Granting server-level roles to Azure AD Logins

347 views Asked by mark At 07 March 2023 at 16:17

score 807 · Answer 5 · 2023-01-06T12:07:36.880000

What is the difference in TMSCHEMA vs MDSCHEMA in DMV of Power BI models

807 views Asked by Przemyslaw Remin At 06 January 2023 at 12:07

score 87 · Answer 6 · 2023-01-05T14:41:49.170000

Get lineage id of a measure from thin pbix file

87 views Asked by Przemyslaw Remin At 05 January 2023 at 14:41

score 63 · Answer 7 · 2022-12-08T12:31:59.510000

Extract measure alias assigned in a visual

63 views Asked by Przemyslaw Remin At 08 December 2022 at 12:31

score 80 · Answer 8 · 2022-10-05T14:30:41.513000

sys.dm_db_index_usage_stats from SMO with powershell script

80 views Asked by evil-cat At 05 October 2022 at 14:30

score 77 · Answer 9 · 2022-06-21T20:39:21.687000

Find resource_name used for stalled sp_getapplock call

77 views Asked by Robert Sievers At 21 June 2022 at 20:39

score 328 · Answer 10 · 2022-06-04T23:25:30.567000

Is there a way to build TMSL scripts programatically on the same way that XMLA tools create it (like Tabular editor) from an existent tabular db?

328 views Asked by A Echague At 04 June 2022 at 23:25

score 189 · Answer 11 · 2022-04-08T10:45:39.007000

Issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated

189 views Asked by Lee At 08 April 2022 at 10:45

score 115 · Answer 12 · 2022-01-14T18:30:21.477000

DMV request for "Description" of the table for Power BI dataset

115 views Asked by Oleg Kazanskyi At 14 January 2022 at 18:30

score 1714 · Answer 13 · 2021-12-27T22:55:15.370000

Excel Power Query truncating text field to 1024 characters

1.7k views Asked by TheRizza At 27 December 2021 at 22:55

score 93 · Answer 14 · 2021-09-03T13:54:09.673000

How to return columns based on selection or add that as parameter in stored procedure

93 views Asked by Newbie-DBA At 03 September 2021 at 13:54

score 202 · Answer 15 · 2021-06-01T20:29:03.330000

How to join DMVs to get the data for finding queries running on certain CPU id in SQL Server

202 views Asked by Newbie-DBA At 01 June 2021 at 20:29

score 258 · Answer 16 · 2021-05-16T01:01:36.453000

How can I write this function to calculate datetime diff as hh:mm:ss:ms

258 views Asked by Newbie-DBA At 16 May 2021 at 01:01

score 231 · Answer 17 · 2021-05-06T13:02:09.853000

Really slow DISCOVER_CSDL_METADATA in SQL Server Profiler

231 views Asked by Marcin At 06 May 2021 at 13:02

score 665 · Answer 18 · 2021-04-28T16:12:04.007000

How to execute a DMV query in SSAS through a powershell runbook from Azure Automation?

665 views Asked by FabioBeka At 28 April 2021 at 16:12

score 332 · Answer 19 · 2021-04-24T18:33:04.030000

SQL server DMV (Dynamic Management View) not showing last user update info on table with 2 indexes

332 views Asked by gwoo At 24 April 2021 at 18:33

score 1798 · Answer 20 · 2020-10-12T13:53:36.423000

How to find blocking session ID for my SP

1.7k views Asked by xhr489 At 12 October 2020 at 13:53

TechQA.

List Question

JOIN on partition_id or hobt_id?

Delete from SQL Server 2017 QueryStore dmv issue

VERY strange behavior of sys.dm_hadr_database_replica_cluster_states in a SQL Job

Granting server-level roles to Azure AD Logins

What is the difference in TMSCHEMA vs MDSCHEMA in DMV of Power BI models

Get lineage id of a measure from thin pbix file

Extract measure alias assigned in a visual

sys.dm_db_index_usage_stats from SMO with powershell script

Find resource_name used for stalled sp_getapplock call

Is there a way to build TMSL scripts programatically on the same way that XMLA tools create it (like Tabular editor) from an existent tabular db?

Issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated

DMV request for "Description" of the table for Power BI dataset

Excel Power Query truncating text field to 1024 characters

How to return columns based on selection or add that as parameter in stored procedure

How to join DMVs to get the data for finding queries running on certain CPU id in SQL Server

How can I write this function to calculate datetime diff as hh:mm:ss:ms

Really slow DISCOVER_CSDL_METADATA in SQL Server Profiler

How to execute a DMV query in SSAS through a powershell runbook from Azure Automation?

SQL server DMV (Dynamic Management View) not showing last user update info on table with 2 indexes

How to find blocking session ID for my SP

Popular Questions

Trending Questions