गोल्ड पोकेट कस्टमर केयर नंबर 8807418515//8961224235callगोल्ड पोकेट कस्टमर केयर नंबर 8807418515//8961224235call
Great day am going to a great day am I going to a great time am I going to
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks
Hi Team, Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%% On analysis I find that the row identifier - %%LOCKRES%%…
Error While Installing SQL server 2022 Developer Error result: -2068052310
An Error Occurs while installing the SQL server 2022 Developer edition and the Error Code is -2068052310
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…
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,…
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
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…
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.
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…