SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2024-03-20T12:58:32.6433333+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(44.800000000000004, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYT%3C/text%3E%3C/svg%3E)
yensur thahir112
0
Reputation points
commented 2025-02-22T21:39:54.42+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(297.6, 25%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
ahmed farouk
0
Reputation points
0 answers
No drag and drop on SQL Server Management Studio on external display after installing update KB5051987
After installing the following update last Tuesday, I've lost the drag and drop feature in SQL Server Management Studio: 2025-02 Cumulative Update for Windows 11 Version 24H2 for x64-based Systems (KB5051987) The mouse drag'n'drop is completely disabled…
asked 2025-02-21T20:13:46.6+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(288, 69%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alberto Silva
0
Reputation points
commented 2025-02-22T17:16:14.0766667+00:00
Viorel
120.1K
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to Install SQL server 2022
Got this error while trying to install SQL Server 2022 Express edition. I restarted my laptop and tried again, still no luck. Also checked the summary log in the installation folder and the only info I can get from it is that I need a valid copy of the…
asked 2023-09-26T20:45:59.9733333+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(80, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOP%3C/text%3E%3C/svg%3E)
Owen Patrick
20
Reputation points
commented 2025-02-22T09:41:08.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(278.4, 95%, 36%)' 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)
Minas Kotsis
0
Reputation points
2 answers
indic_general_90_ci_as was not found
I am trying to install SQL SERVER 2014 version but I am getting "indic_general_90_ci_as was not found" error. I have attached the screenshot of the error as well. Kindly help me how to fix this error. What does this error mean?
asked 2025-02-19T08:38:06.2933333+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, 57.99999999999999%, 18%)' 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)
Sudipto Deb
0
Reputation points
commented 2025-02-21T22:01:01.31+00:00
Erland Sommarskog
117.4K
Reputation points MVP
1 answer
SQL Server 2022 error when downloading – taking more than 24 hours and still not resolved!
From my research, it seems that everyone is facing this issue, yet there is still no solution. I’m not sure what Microsoft is waiting for to fix this problem. I have completely uninstalled and reinstalled it, but I keep encountering the same issue. I…
asked 2025-02-21T15:45:18.37+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(304, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
James Flush
0
Reputation points
answered 2025-02-21T18:34:27.26+00:00
Dan Guzman
9,266
Reputation points
0 answers
How to connect azure automation account to azure sql server which has private endpoint enabled
How to connect azure automation account to azure sql server which has private endpoint enabled
asked 2025-02-19T06:46:20.4933333+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(211.20000000000002, 0%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yuvaraj Sonale
0
Reputation points
commented 2025-02-21T17:35:06.13+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(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi
80
Reputation points Microsoft Vendor
1 answer
Region-specific drives for a VM located in Azure AU region
Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…
asked 2025-02-06T23:25:40.6466667+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(92.8, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Berchmans Marcelline
15
Reputation points
commented 2025-02-21T16:37:59.1433333+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(304, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Keshavulu Dasari
3,380
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Function on Column used in Index - need optimization advice
First, is this the proper forum for MS SQL tsql questions? Why am I seeing only 114 questions? OK, so we have a table ods_DDAHIS which has a TransDate column that is numeric in format YYYYMMDD. There is an index on ods_DDAHIS.Transdate. Then view…
asked 2025-02-18T21:38:57.8033333+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(9.6, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Grossnickle, Brenda
120
Reputation points
accepted 2025-02-21T15:26:40.43+00:00
Grossnickle, Brenda
120
Reputation points
2 answers
SSRS report with datetime parameter shown as text field
A client is complaining when he runs a report inside of the system where it runs inside of an iframe the two datetime pickers re rendered as textboxes, but running it directly works fine. Any idea?
![](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(297.6, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
SSIS An error occurred while attempting to perform a type cast.
The SQL Server has been updated to SQL 2022 (compatibility mode 150). The same file that works in production, now gives an error in Stage Error: 0xC0049064 at Load Flat File, Derived Column File [2]: An error occurred while attempting to perform a type…
asked 2025-02-20T16:35:43.11+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(137.6, 31%, 23%)' 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)
Naomi Nosonovsky
8,191
Reputation points
accepted 2025-02-21T11:46:26.7+00:00
Naomi Nosonovsky
8,191
Reputation points
1 answer
One of the answers was accepted by the question author.
How to add total sum of per Customer under each ID
I have a demo table like this: OrderID CustomerID ProductID OrderAmount OrderDate 1 101 201 100.00 2024-08-01 00:00:00.000 2 101 202 150.00 2024-08-03 00:00:00.000 3 102 201 200.00 2024-08-10 00:00:00.000 4 101 203 120.00 2024-09-15…
![](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(195.2, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
0 answers
Assistance Needed with SQL Server Installation and Setup
I am experiencing difficulties while trying to install SQL Server 2019 on my machine. Despite following all necessary steps, I am encountering issues that prevent me from successfully setting up the server. Specifically, I am facing challenges when…
asked 2025-02-20T14:54:12.08+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(150.4, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
David Dimitrov
0
Reputation points
commented 2025-02-21T02:39:14.3833333+00:00
LiHongMSFT-4306
30,901
Reputation points
3 answers
how to include 2 tables in 1 page and page break down by 1 column for both the tables in ssrs report
I have 2 tablix pointing 2 different dataset in a report. Each tablix pointing to different dataset. Monthly Sales CountrySalesAmountUS100UK200YTD Sales CountrySalesAmountUS150UK250When applied page break on Country column in both tablixes, it should…
asked 2025-02-19T17:25:03.98+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, 27%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mysari Gnaneshwar
5
Reputation points
answered 2025-02-21T02:38:17.3333333+00:00
ZoeHui-MSFT
40,901
Reputation points
1 answer
Request: Safe Updates Feature in SQL
This feature prevents UPDATE or DELETE queries from executing unless they include a WHERE clause or a LIMIT. It's a safeguard against accidental table-wide modifications and helps maintain data integrity. I believe SQL Server would greatly benefit from a…
asked 2025-02-20T15:40:18.7433333+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(44.800000000000004, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mohammad.safyar
0
Reputation points
commented 2025-02-21T01:53:17.92+00:00
LiHongMSFT-4306
30,901
Reputation points
2 answers
SQL Server 16 Install
I am trying to install SQL Server 16. I run the install and it completes normally but when I create an instance it puts it under SQL Server 13 and if I try to restore from .BAK file in SSMS I get an error message that I .BAK file SQL Server 16 and cant…
![](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(291.2, 71%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
0 answers
How to fix sql server having a stuck ExportDatabase job at 1%, cancelling leads to stuck CancelInProgress instead
We were doing an ExportDatabase operation on our production database. This is part of our release pipeline, to do a backup before deploying new code. The github action timed out eventually since the export job got stuck at 1% and was stuck for 8 hours.…
asked 2025-02-18T08:04:09.8533333+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(304, 76%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kalle Macklin
0
Reputation points
commented 2025-02-20T22:07:36.2666667+00:00
Erland Sommarskog
117.4K
Reputation points MVP
4 answers
When attempting to add a second SQL VM to a SQL VM Group getting a ping failure
I can create the SQL VM Group successfully, add the first SQL VM to it and everything works as expected there. The cluster is created and the node is added to it. However, when I attempt to add a second SQL VM I get this error: Error code:…
![](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(294.40000000000003, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
1 answer
ODBC Source Task - KISAM ODBC Driver - Unable to retrieve list of tables or run SQL script
I'm attempting to upgrade a package from SSDT_BI 2013 to Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT) with version 15.1.62002.01090. However, I'm encountering an issue where I cannot retrieve the list of tables or execute SQL scripts…
asked 2023-08-24T06:49:50.4433333+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(16, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vani Priya
5
Reputation points
commented 2025-02-20T17:31:33.77+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(185.6, 9%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lund
0
Reputation points
2 answers
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ? I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc. I don't find the exact product version. For instance,…
asked 2025-02-17T19:00:55.1133333+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(60.8, 61%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jean-Marie Roger
0
Reputation points
commented 2025-02-20T16:28:00.6466667+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(256, 20%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pranay Reddy Madireddy
2,095
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
High parallelism in Query Store.
Greetings. As you see in the screen shot the bulk of my wait time is going to one wait type. A few fun facts: This is in a reporting type DB with the bulk of activity coming from ETL and Power BI queries, no OLTP type stuff at all. Maxdop on 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(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)