Question

JOIN on partition_id or hobt_id?

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

110

Views

JOIN on partition_id or hobt_id?

Published on 26 October 2023 at 22:52

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

221

Views

Delete from SQL Server 2017 QueryStore dmv issue

Published on 31 May 2023 at 06:53

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

65

Views

VERY strange behavior of sys.dm_hadr_database_replica_cluster_states in a SQL Job

Published on 13 March 2023 at 21:05

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

347

Views

Granting server-level roles to Azure AD Logins

Published on 07 March 2023 at 16:17

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

807

Views

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

Published on 06 January 2023 at 12:07

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

87

Views

Get lineage id of a measure from thin pbix file

Published on 05 January 2023 at 14:41

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

63

Views

Extract measure alias assigned in a visual

Published on 08 December 2022 at 12:31

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

80

Views

sys.dm_db_index_usage_stats from SMO with powershell script

Published on 05 October 2022 at 14:30

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

77

Views

Find resource_name used for stalled sp_getapplock call

Published on 21 June 2022 at 20:39

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

328

Views

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?

Published on 04 June 2022 at 23:25

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

189

Views

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

Published on 08 April 2022 at 10:45

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

115

Views

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

Published on 14 January 2022 at 18:30

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

1.7k

Views

Excel Power Query truncating text field to 1024 characters

Published on 27 December 2021 at 22:55

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

93

Views

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

Published on 03 September 2021 at 13:54

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

202

Views

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

Published on 01 June 2021 at 20:29

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

258

Views

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

Published on 16 May 2021 at 01:01

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

231

Views

Really slow DISCOVER_CSDL_METADATA in SQL Server Profiler

Published on 06 May 2021 at 13:02

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

665

Views

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

Published on 28 April 2021 at 16:12

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

332

Views

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

Published on 24 April 2021 at 18:33

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

1.7k

Views

How to find blocking session ID for my SP

Published on 12 October 2020 at 13:53

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

Trending Questions

Popular # Hahtags

Popular Questions