SQL Server

Typo on page

Hi, where do we give feedback for a typographical error on a MS Learn page? https://learn.microsoft.com/en-us/training/modules/sql-server-2022-performance-enhancements/3-memory-feedback-exercise Item 6. IsMemoryGrangFeedbackAdjusted should be…

How can I fix this problem

I have windows 11 laptop, how can I fix this problem?

I tried to install SQL but I couldn't open it. Errors keep popping up. I uninstalled all the previous SQL Database applications or features and restarted my PC but it didn't work. Two days passed fixing this but still, I didn't know what's the problem.…

SQL19 express installation Error

I'm trying to install 'Microsoft SQL Server 2019 Express' with below steps: Used Custom Installation step From SQL Server Installation Center: I've selected 'New SQL Server Standalone installation' In the feature selection, I've selected a.…

CPU used query return wrong result

Hi, After the CPU upgrade to 98 cores when I execute the query to find the sqlserver usage and system idle shows the result more than 100%. for example SQL Server process utilization - 20 System idle process - 89 The query which I used was Please help…

Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)

After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…

How to force a rollback of SQL Server to stop

I'm registering or updating a lot of data in DB in SQL Server. Due to circumstances, this transaction is a very large unit, and if an error occurs, a rollback of more than 24 hours occurs. In this situation, is there an emergency way to force the…

SQL Server 2022 Express installation - how to fix 'error while checking Rules of Sql Server set up'?

Hello, I am having trouble installing SQL Server 2022 Express Edition, Basic installation type. I keep getting this error during installation: "There was an error while checking Rules of Sql Server setup" I have so far tried: Restarting my…

SSMS hangs for an extended period when closing a query tab or object explorer when a connection cannot be established to the SQL Server

Suppose I am connected via VPN to a network that includes a SQL server. I then open SSMS and connect to that server. Eventually the VPN loses connection or I disconnected (work is finished for the day, whatever) I then attempt to close an SSMS…

Completely remove Ledger Table from Database

Is there a way how to completely remove Ledger table from a database and reclaim disk space? History table can take gigabytes, and I want to remove all the data related to some ledger table. Data and history. But I don't see how it can be done.

Install SCOM 2022 on Windows Server 2022

Hi, I have evaluations of Windows Server 2022, SQL Server 2022 and SCOM 2022. I have a Windows Server VM on VMware Workstation. I want to install SCOM. I'm using this link…

SQL managed instance stopped saying I got the vCore 720 reached

I've create a resource of SQL managed instance with the new offer of free vCore 720 hours/month for 12 months. But after 2 weeks the database stopped saying I got the vCore 720 reached. Is that right? I've created just 1 database in the instance. How can…

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…

How to lock transactions that cannot be ended autonomously

An abnormal table lock was detected in the production environment. Tracking revealed a transaction that lasted for several hours, which was conspicuous in a production setting where transactions typically last no more than 30 seconds. Monitoring through…

Set up valuable Indexes on a table

I have a really big transaction table, billions of rows, and I need some kinds of Indexes to make it useful. Right now there is a clustred columnstore index on the table, and a nonclustred on ID, but I guess I need some nonclustred to make the table…

Hash table creation issue in Sql server

I have created hash table in outer procedure with 2 columns and trying to create another hash table with same name but 3 columns. Now if i try to insert into hash table in inner procedure i get error saying not able to access third column (which was not…

exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help

This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…

i have few snapshot transactions, now i need to put nolock/read uncommit for perticular table

hi, I have few snapshot transactions , now my admin has informed me that put no lock in all tables in snapshot transactions, as it was blocking locking deadlocking with others. so I suggested to put read uncommited instead of snapshot when u are…

Power BI Sources and Education

Just looking for some good Power BI resources and education materials...web sites...YouTubes And is there a separate Forum for Power BI? Because I cannot seem to tag anything with "Power BI" here. Thanks in advance for your review and help.

Buffer Cache and Buffer Pool

Hi, What is the difference between Buffer Cache and Buffer Pool?