SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,220 questions
0 answers
How do I empty data the PRIMARY filegroup to allow more space for new data?
Hello all, I'm currently getting a database error on my SCADA ignition client. New to the SQL world, I did see however that our max file size is 10GB for the SQL Express edition. Looking to make room for the new data coming in. Any Insite would be much…
asked 2024-12-26T14:01:03.8566667+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(48, 95%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Matthew Treadway
0
Reputation points
commented 2024-12-26T15:39:41.26+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
How to connect the Powerbi Report Server to sqlserver with "force encryption" enabled
Dear Support: we are trying to setup the PowerBI report server on our local environment, and according to our security policy, we are forced to activate the "force encryption" in SQL server, which makes us not able to connect to database…
asked 2024-12-26T11:09:08.14+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, 22%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sun, Dong Wei (IN IT CN RS)
0
Reputation points
commented 2024-12-26T12:57:39.6633333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
How to connect the Powerbi Report Server to sqlserver with "force encryption" enabled
Dear Support: we are trying to setup the PowerBI report server on our local environment, and according to our security policy, we are forced to activate the "force encryption" in SQL server, which makes us not able to connect to database…
asked 2024-12-26T11:09:08.14+00:00
Sun, Dong Wei (IN IT CN RS)
0
Reputation points
commented 2024-12-26T12:57:39.6633333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
help me with this error
This error appears when trying to cascade the relationship between a primary key and a foreign key " 'Employees' table saved successfully 'PC_details' table Unable to create relationship 'FK_PC_details_Employees'. Introducing FOREIGN KEY…
asked 2024-12-26T12:03:52.3633333+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(128, 9%, 22%)' 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)
medooouni1980
0
Reputation points
answered 2024-12-26T12:55:24.25+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
Enabling OAuth 2.0 for SQL Server Database Mail System
Hello Team, I previously encountered an issue with sending emails from SQL Server where I received an authentication error due to basic authentication being disabled. The team suggested implementing OAuth 2.0, but I struggled to find proper articles or…
asked 2024-12-26T10:43:38.2233333+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(32, 8%, 13%)' 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)
Avinash
20
Reputation points
commented 2024-12-26T11:31:00.3233333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
SQL Server Enterprise 2019 not core 21 up to
Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server. I have tried the following commands: EXEC sp_configure 'affinity mask', 0; EXEC…
asked 2024-12-26T04:30:18.3066667+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(307.2, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nguyen ngoc giang
0
Reputation points
commented 2024-12-26T09:29:49.33+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
SQL Server Enterprise 2019 not core 21 up to
Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server. I have tried the following commands: EXEC sp_configure 'affinity mask', 0; EXEC…
asked 2024-12-26T04:30:18.3066667+00:00
Nguyen ngoc giang
0
Reputation points
commented 2024-12-26T09:29:49.33+00:00
Erland Sommarskog
114.6K
Reputation points MVP
0 answers
Error installing SQLEXPRESS 2022
Hi i want to install SQL EXPRESS 2022 but everytime i get an error , clean install does'nt work also upgrade previous version 2017 does'nt work
asked 2024-12-26T08:18:00.1+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(6.4, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tom Hemeryck
0
Reputation points
commented 2024-12-26T09:21:08.8733333+00:00
Erland Sommarskog
114.6K
Reputation points MVP
3 answers
AlwaysON issue v2
Hello! There are two newly installed SQL Server 2022 Standard servers installed from the same ISO(say SQL1 and SQL2), OS = WinServer 2022 Standard (for both servers, same ISO), both added to the domain with the single domain controller named DC1. Here's…
asked 2024-12-06T14:46:03.6333333+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(214.4, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hram Admin
40
Reputation points
commented 2024-12-26T09:13:09.1266667+00:00
Hram Admin
40
Reputation points
1 answer
How to display different percent in report
I have set the percentage as 5.2%, when it is 5%, it will show as 5.0%. I want to remove the decimal when it comes with whole value.
asked 2024-12-24T06:39:08.7633333+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(265.6, 3%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yun
40
Reputation points
commented 2024-12-26T02:34:30.77+00:00
ZoeHui-MSFT
38,951
Reputation points
asked 2024-12-25T18:15:17.4566667+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, 61%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phuc Nguyen
0
Reputation points
commented 2024-12-26T01:48:40.0766667+00:00
LiHongMSFT-4306
29,516
Reputation points
0 answers
alert not triggering on azure sql
Hi , we configured alert rule for static ,aggregation type average, greater then , threshold 40% on sql db ealier alerts was worked last few days not working this prod db we are facing lot of issue unless see the metrics then we know the cpu status…
asked 2024-12-18T14:04:00.7733333+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(259.20000000000005, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Surapally Sravan Kumar
0
Reputation points
commented 2024-12-25T17:43:26.5+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,005
Reputation points Microsoft Vendor
2 answers
I am not able to Connect to SQL Server when system administrators are locked out
My administrator account is locked. I followed the step provided here https://zcusa.951200.xyz/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?redirectedfrom=MSDN&view=sql-server-ver15…
asked 2024-12-24T14:54:47.86+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(188.79999999999998, 32%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Lokesh Kumar Pattajoshi
0
Reputation points
answered 2024-12-25T02:49:24.1666667+00:00
ZoeHui-MSFT
38,951
Reputation points
1 answer
Alternative approaches for Recursive CTE in SQL server. The data is 1 million records. need to calculate the current value based on previous value and iterate through Million records. Please suggest a methods which performs better than Recursive CTE
here is the query for your reference. Thanks! Alternative approaches for Recursive CTE in SQL server. The data is 1 million records. need to calculate the current value based on previous value and iterate through Million records. Please suggest a…
asked 2024-12-24T08:30:28.83+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, 79%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
roopa g
20
Reputation points
answered 2024-12-25T01:53:37.3033333+00:00
LiHongMSFT-4306
29,516
Reputation points
1 answer
Alternative approaches for Recursive CTE in SQL server. The data is 1 million records. need to calculate the current value based on previous value and iterate through Million records. Please suggest a methods which performs better than Recursive CTE
here is the query for your reference. Thanks! Alternative approaches for Recursive CTE in SQL server. The data is 1 million records. need to calculate the current value based on previous value and iterate through Million records. Please suggest a…
asked 2024-12-24T08:30:28.83+00:00
roopa g
20
Reputation points
answered 2024-12-25T01:53:37.3033333+00:00
LiHongMSFT-4306
29,516
Reputation points
1 answer
One of the answers was accepted by the question author.
Changing the x-axis properties in a SSRS chart does not work when there are negative values.
I want to emphasize the x-axis of a chart in SSRS by increasing its point size. When there are negative values, the axis that shows the emphasis is not the zero value as shown in the picture. The zero line is the one I want to be dark. The labels at 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(182.40000000000003, 44%, 27%)' 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)
1 answer
SQL Server 2022 Kurulum Hatası
SQL Server 2022 Detail.txt Summary_DESKTOP-UN0800B_20240602_203435.txt Summary.txt Exit Code (Decimal): -2068052377 Error Description: Geçersiz komut satırı bağımsız değişkeni (Invalid command line argumant)
asked 2024-06-02T17:55:45.07+00:00
Kadir Veysel SAYAR
25
Reputation points
edited a comment 2024-12-24T18:02:25.2866667+00:00
Kadir Veysel SAYAR
25
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to install SQL Server 2022 Express. Error code : 2068052294
I tried several times to download and install SQL Server 2022 Express from the official web (https://www.microsoft.com/en-us/sql-server/sql-server-downloads) and every time I got an error message that caused the installation to stop. I deleted all…
asked 2024-12-23T10:06:27.9566667+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(224.00000000000003, 38%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Naimer
20
Reputation points
commented 2024-12-24T16:53:31.82+00:00
Erland Sommarskog
114.6K
Reputation points MVP
1 answer
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
asked 2024-12-20T10:18:09.9266667+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(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjeev K
20
Reputation points
commented 2024-12-24T16:15:03.2166667+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,470
Reputation points Microsoft Vendor
1 answer
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
asked 2024-12-20T10:18:09.9266667+00:00
Sanjeev K
20
Reputation points
commented 2024-12-24T16:15:03.2166667+00:00
Mahesh Kurva
1,470
Reputation points Microsoft Vendor