Viewing 15 posts - 1 through 15 (of 303 total)
I will just provide some details.
As of last week, almost everyone had access to run select against some restricted views
Then I generated the list of users who had read only...
March 26, 2024 at 3:24 pm
I did suggest creating a new table, dumping only Feb 2024 data, renaming the new one and old one. No response yet from the user.
Also, this table has 4 indexes.
1...
February 29, 2024 at 2:23 pm
I changed the Legacy cardinality Estimation setting to ON and now both queries are taking the same time.
October 26, 2023 at 1:37 pm
Hey experts, I am really hoping to get any feedback. Just trying to understand why this behavior...
October 6, 2023 at 7:11 pm
I came across an article where I had to add 1 in the end like reports1, restart the services and viola it worked. Changing it back to reports worked as...
September 22, 2023 at 1:24 pm
I made the changes based on your recommendations so now the plain report is displayed when I use https://server/ReportServer but then I get HTTP Error 404. The requested...
September 22, 2023 at 1:12 pm
I followed this RSExecRole document, recreated the role, granted all necessary permissions, restarted reporting server but getting the same error. I have admin rights on the server. The service...
January 27, 2021 at 6:13 pm
This role doesn't exist on Dev and Prod but I am able to manage the subscription. However, I am going to create this role as well as grant permissions
NT**** already...
January 26, 2021 at 4:02 pm
I just checked log_reuse_wait_desc and it shows 'AVAILABILITY_REPLICA'. I know now what's causing this.
Thanks for the help.
September 18, 2020 at 2:22 pm
Hi,
if you got this error next time, just take a look at this query:
SELECT
name AS DatabaseName,
log_reuse_wait_desc AS LogBlocking,
...
May 5, 2020 at 12:13 pm
Sorry, found a solution. We have a DAG and someone was working on DR server so DBs is out of sync and that's what causing the issue.
May 4, 2020 at 2:19 pm
Sue_H, screenshots which I shared last week were from the Extended events session for the Always on health.
February 3, 2020 at 2:37 pm
I believe we have 4 servers (Node1, Node2, node3 and node4) in one subnet. All physical servers. Environment details.
Node1 act as a primary for 1st AG. Node 2, Node 3...
January 27, 2020 at 3:58 pm
This is the patch level we are on.
Microsoft SQL Server 2016 (SP2-CU10) (KB4524334) - 13.0.5492.2 (X64)
January 24, 2020 at 12:14 pm
Viewing 15 posts - 1 through 15 (of 303 total)