14,662 questions
2 answers
Can a SQLServer 2016 AG with one database be setup with two separate Managed Instance Links?
I’m planning a migration of a SQL Server 2016 Always On AG with a single 4TB database to Azure SQL Managed Instance. We already have one MI acting as a read‑replica for reporting and analytics. As part of the migration, I’m considering deploying a second…
SQL Server | Other
asked 2026-02-13T20:22:46.6633333+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, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abimbola Adeniran
86
Reputation points
answered 2026-02-14T01:00:38.8133333+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, 2%, 11%)' 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)
Manoj Kumar Boyini
7,430
Reputation points Microsoft External Staff
Moderator
1 answer
AI training around SQL server DBA with certification - copilot for SQL server DBA will be great
AI training around SQL server DBA with certification - copilot for SQL server DBA will be great
SQL Server | Other
14,662 questions
asked 2026-02-13T20:54:30.8433333+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(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Sultan Zeb
0
Reputation points
answered 2026-02-13T20:54:37.7866667+00:00
Q&A Assist
2 answers
License SQL Server Developer
Can I use SQL Server Developer license in a server for only tests and development?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-13T19:17:36.0433333+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(35.2, 54%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
GTI - Mstech
0
Reputation points
answered 2026-02-13T20:23:05.61+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-01-30T13:50:19.4766667+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(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
commented 2026-02-13T15:21:43.57+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
1 answer
What effects does the ARITHABORT setting have on how query plans are created?
Please note I am not looking for advice on how to optimize specific queries. In my SQL Server environment I have come across the all too common "slow in application but fast in SSMS" issue many times. Our application sets ARITHABORT OFF by…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T23:21:55.0566667+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, 70%, 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)
Jacob Booher
0
Reputation points
commented 2026-02-13T12:43:14.32+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
SQL authorization lost
請問:電腦中毒重灌,SQL需重新安裝,2020年購買的SQL授權遺失(當初是一張貼紙)，要如何申請取回?謝謝
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
594 questions
asked 2026-02-13T08:57:35.6066667+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(176, 74%, 27%)' 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)
木蘭 陳
0
Reputation points
answered 2026-02-13T12:04:03.8666667+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, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
750
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Licences South Africa
I cannot find an email address to contact Microsoft to ask about third party suppliers for SQL Server Licenses DigiSoft-ZA are advertising SQL Server Standard 2025 for R 19,999. When questioned by email they advised this was 16 Core, Lifetime License,…
SQL Server | Other
14,662 questions
asked 2026-02-12T13:08:15.0433333+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, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
Brad Woolley
0
Reputation points
commented 2026-02-13T10:36:58.6066667+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
3 answers
STAR Schema Model Design
Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
![](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, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
0 answers
Cannot connect to SQL Server
Let say i have server A and two sql server, SQL1 and SQL2. When Server A try connect to SQL1 then i got below error from SSMS, but if connect to SQL2 then the conneciton is working fine. Other servers beside Server A can connect to both SQL. A Anyone…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-10T01:37:21.5066667+00:00
Handian Sudianto
6,726
Reputation points
commented 2026-02-13T04:08:15.9833333+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,160
Reputation points Microsoft External Staff
Moderator
2 answers
we would like to setup DR nodes for all existing production SQL servers
we would like to setup DR nodes for all existing production SQL servers DR site would be more than 200 miles , what is the best recommendations in terms of network, servers and SQL server editions etc
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T07:00:00.12+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(124.80000000000001, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sampath Challagonda
0
Reputation points
answered 2026-02-12T22:55:23.2933333+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
How to create initial full backup followed by transaction logs daily?
This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…
SQL Server | SQL Server Transact-SQL
266 questions
asked 2026-01-30T18:06:58.63+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(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
980
Reputation points
commented 2026-02-12T22:53:01.99+00:00
Justin Doh
980
Reputation points
2 answers
how to install and find MS SQL Server Management Studio 2019
I cannot find old version setup for 2019 Management studio anywhere , please guide me or share link from where i can download.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T07:51:39.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(227.2, 88%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Asif Khan
0
Reputation points
recommended 2026-02-12T22:45:15.26+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
1 answer
SQL server 2022 installation fails at MOF stage on Windows server 2025 24H2 (26100)
I am trying to install the windows HLK controller + studio on Windows server 2025 24H2 (26100) and failed at SQl installation leading to get to know SQL 2022 server edition installation fails at MOF stage of intallation with error "MOF connection…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T08:45:48.5033333+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(156.8, 61%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rahul K Nair
0
Reputation points
commented 2026-02-12T22:44:07.1033333+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
1 answer
Unable to login On-Prem SQL server
Hi Team, We are not able to login On-Prem SQL server. Could you please help with this.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T17:23:33.8433333+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, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vikash Kumar (HCL Technologies Corporate Services)
0
Reputation points Microsoft External Staff
commented 2026-02-12T22:36:53.3866667+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
4 answers
SQL Server 2025 executing request with in SQL connexion is very slow
Hello, I installed SQL 2025 on a new VM to test the installation of my application, which currently runs on SQL 2022. I’m facing an issue with SQL 2025 (fresh installation on a new machine with a new DB): the queries are extremely slow when I use a SQL…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2025-12-15T07:24:18.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(310.4, 57.00000000000001%, 40%)' 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)
MT
25
Reputation points
commented 2026-02-12T22:28:48.7566667+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
DBF Table named Order in VFP
DBF Table named Order in VFP i think you can't have a tlb named order can anyone help with this problem. Update ORDER ; SET ORDER.GROUP = 'Apples' ; WHERE ORDER.GROUP == 'Apple'
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-03T00:46:31.6266667+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, 12%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
Paul Waldner
0
Reputation points
commented 2026-02-12T14:48:38.82+00:00
Paul Waldner
0
Reputation points
2 answers
MSDASQL ODBC queries to Linked Servers hang with no response after a couple weeks.
Hi all, Our current setup is a linked server to NetSuite ODBC using MSDASQL 17 as the provider. Everything works and runs fine and fast for about 2 weeks. Then the error will occur. There will be no error message or anything, but the query just…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-05T18:29:07.92+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(230.39999999999998, 40%, 32%)' 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)
Ted
0
Reputation points
commented 2026-02-12T21:34:47.46+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
How can I create TRN file to capture only difference daily (between TRN files)?
I am trying to understand how Transaction Log works. This question is related to my previous post. My requirement is, instead of providing BAK file (because it is huge), I am trying to generate one TRN file daily for any change (insert, update or delete)…
SQL Server | SQL Server Transact-SQL
266 questions
asked 2026-02-05T20:07:21.91+00:00
Justin Doh
980
Reputation points
accepted 2026-02-12T18:03:29.3766667+00:00
Justin Doh
980
Reputation points
0 answers
Why am I getting this exit code 14 error in my project logs?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-09T14:18:18.99+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(230.39999999999998, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Raghavendra Katageri
0
Reputation points
commented 2026-02-12T11:41:57.4833333+00:00
Akhil Gajavelly
1,160
Reputation points Microsoft External Staff
Moderator
1 answer
where can i download sql standard 2022
where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
628 questions
asked 2026-02-12T22:06:22.7933333+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(115.19999999999999, 42%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Franklin Husselbee
0
Reputation points
answered 2026-02-12T22:07:55.65+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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
77,420
Reputation points MVP
Volunteer Moderator