SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,950 questions
2 answers
गोल्ड पोकेट कस्टमर केयर नंबर 8807418515//8961224235callगोल्ड पोकेट कस्टमर केयर नंबर 8807418515//8961224235call
Great day am going to a great day am I going to a great time am I going to
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
0 answers
%%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%%…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 67%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
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
asked 2024-06-02T03:10:55.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jemis Bakarania
0
Reputation points
accepted 2024-06-02T04:15:50.38+00:00
Jemis Bakarania
0
Reputation points
7 answers
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM2%3C/text%3E%3C/svg%3E)
2 answers
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,…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
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?
asked 2024-05-03T12:16:54.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 5%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
AJ Copeland
0
Reputation points
commented 2024-06-02T01:40:42.91+00:00
AJ Copeland
0
Reputation points
1 answer
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…
asked 2024-05-31T19:07:21.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 24%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Ric Oliva
0
Reputation points
edited an answer 2024-06-01T20:36:51.1466667+00:00
Erland Sommarskog
102.5K
Reputation points
0 answers
asked 2024-06-01T18:47:44.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 64%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Kartik Tautwar
0
Reputation points
commented 2024-06-01T19:10:05.72+00:00
Erland Sommarskog
102.5K
Reputation points
1 answer
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.…
asked 2024-06-01T18:36:12.7166667+00:00
Kartik Tautwar
0
Reputation points
answered 2024-06-01T18:42:26.33+00:00
Erland Sommarskog
102.5K
Reputation points
0 answers
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.…
asked 2024-06-01T08:58:03.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pramod Kumar
0
Reputation points
commented 2024-06-01T17:59:36.39+00:00
Erland Sommarskog
102.5K
Reputation points
3 answers
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
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,…
asked 2024-05-30T16:41:17.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Kehoe, Tim
0
Reputation points
commented 2024-06-01T15:45:04.3233333+00:00
Kehoe, Tim
0
Reputation points
4 answers
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 52%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
1 answer
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…
asked 2024-05-29T12:02:47.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 65%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mariel
0
Reputation points
commented 2024-06-01T09:41:48.36+00:00
Erland Sommarskog
102.5K
Reputation points
9 answers
One of the answers was accepted by the question author.
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…
asked 2022-03-15T17:09:44.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 96%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
allmhuran
136
Reputation points
commented 2024-06-01T09:39:52.3933333+00:00
Erland Sommarskog
102.5K
Reputation points
3 answers
One of the answers was accepted by the question author.
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.
asked 2024-05-31T07:38:46.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 71%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOG%3C/text%3E%3C/svg%3E)
Oleg Gelya
20
Reputation points
commented 2024-06-01T06:15:54.4566667+00:00
Oleg Gelya
20
Reputation points
0 answers
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…
asked 2024-05-30T08:48:39.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GK
0
Reputation points
commented 2024-06-01T03:56:27.1033333+00:00
Aki Nishikawa
805
Reputation points Microsoft Employee
2 answers
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…
asked 2024-05-24T00:46:20.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael F. Assis
5
Reputation points
edited a comment 2024-06-01T02:37:55.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 38%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
JOSE ANTONIO VERGARA VEAS
0
Reputation points
1 answer
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…
asked 2024-05-31T09:06:33.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
博雄 胡
70
Reputation points
answered 2024-05-31T21:17:42.5066667+00:00
Erland Sommarskog
102.5K
Reputation points
1 answer
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…
asked 2024-05-31T14:45:31.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Fredrik M
146
Reputation points
answered 2024-05-31T21:10:03.6666667+00:00
Erland Sommarskog
102.5K
Reputation points